On Thu, 17 Aug 2000, Claudio Valderrama C. wrote:

> If you find a program that converts stored procedures between different
> RDBMS systems, please let us know.
> :-)

;-).

> Well, are you speaking about MsSql2IB or PostgreSQL2IB or trying to use
> PostgreSQL as an intermediate step for the conversion? I don't understand
> really what's your data source.

The original data source is MsSQL 7.0 server. But the data are also
available in PostgreSQL if it is easier to do the migration from there.
That's the point.

> Use the UNIX utilities to create INSERT commands based on your columns and
> submit that as an script through IB's isql. Alternatively, download the

So
cat <script> | isql
would work as if I would have typed the stuff in?

> documents, read about the EXTERNAL TABLE feature in IB and create
> fixed-length files for that purpose. If you can use Windows, there's an
> utility called IBLoad that takes a fixed length file and dumps it into an
> Interbase table, without the need to define an external table.

Where can I find IBLoad? It seems not to be in the IBConsole archive.

> > Is there a similar mechanism to the
> > pg_dump | psql
> > thing of PostgreSQL?
>
> I don't have any idea what pg_dump and psql do, so I can't comment. As I
> wrote before, if you create a set of INSERT commands from your data, you can
> use IB's isql to dump the data.

If you are interested about what I've wrote above see my other mail.
This would be the safest way in my opinion.

> I think that the best way you can do is to extract metadata, then tweak it
> and then submit that to IB. I do not trust automatic tools that convert

Me too.

> metadata from one engine to another. If you read the past articles in this
> list, I posted a long email on IB v/s MsSql datatypes and some limitations.

I'll try to search the archive. Unfortunately I'm currently struck with
a terrible connection :-((.

> There's a beta OLE/DB driver in beta for Interbase at
> http://www.lcpi.lipetsk.ru/eng/
> If you can use it to make MsSql to export data to IB once the metadata has
> been created in IB, it would be a good contribution.

I was told to try the replication feature of MS SQL server once I've
tried to migrate to PostgreSQL. May be this is a further way to go for
migration purpose once the ODBC driver is stable. Unfortunately I didn't
managed to use it because of some strange things with the connections.

> This list doesn't solve all your problems. We can help if the users
> interested in conversions spend time in practical solutions, too.
> If you want to have an idea of what GDB and BDE are, go to my site (see
> signature below) and click on DOCUMENTS and then on GLOSSARY.

Thanks for the hint. I'll check that.

Kind regards

Andreas.