Thanks Helen and Jim. I have been trying to do that ... but i have a lot of
tables to convert and the the script that i get my mysqldump and other programs
need a lot of conversions ... close to me changing half the lines in my script
file :-) If there is no other way ... then i guess i have to get started with
the conversion by hand.

Thank you all for the help.

Koushik

--- Jim Wharton <creole3@...> wrote:

>
> 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
> >
> >
> >
> >
> >
>
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>

__________________________________
Do you Yahoo!?
New and Improved Yahoo! Mail - 100MB free storage!
http://promotions.yahoo.com/new_mail