On Sun, 2004-08-15 at 19:15, Helen Borrie wrote:

> At 10:21 AM 15/08/2004 -0700, you wrote:
> >I tried both of them and they did not help. I only have a ODBC provider for
> >MySQL and IBPump needs an OLEDB provider. K2Pump has no options to import
> >from
> >MySQL and I get an error on startup.
> >
> >If need to import the tables, keys and constraints frin MySQL .... I dont need
> >the data. Any suggestions are welcome.
> >
> >Thanks.
>
> http://ems-hitech.com/mysqlutils
> or some other tool that can extract MySQL metadata into a script. (Surely
> MySQL has a native one...)
>
> Once you have a valid script, you can edit it to remove/replace any
> non-standard statements and create your Firebird database from it.
>
> Helen
>

For that matter, you should just be able to use MySQLAdmin to dump the
DDL to a text file. Open the textfile with ViM/Notepad and remove any
data types that are specific to MySQL; auto_increment etc...

I highly suggest you view some sort of migration how-to like:

http://www.interbase-world.com/en/articles/index.php?BID=28&ID=86

Jim

>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>