convert fdb to mysql

I need a tool which can confert fdb files to a mysql sql file or something which can be imported into mysql.

As a note - I have never worked with Firebird until today.

Any help would be appreciated

If you need REAL DATABASE, stay with Firebird

I think that you can use some tool to insert data into MySQL from ODBC source. If you find one, just install Firebird ODBC driver and move into MySQL.
But I think that Firebird is better option.

--
Best regards,
Fikret Hasovic http://fikret.fbtalk.net
TAMP R&D Team
FirebirdSQL Foundation member.
- Join today at http://www.firebirdsql.org/ff/foundation
JEDI VCS contributor
http://jedivcs.sourceforge.net/

Is there any way to go the other direction? Say take a MySql DataBase and import it into FireBird? Or for that matter, a SQL Server database?

Thanks

you can do it the hard way
I dump the database structure from mysql then create the database in firebird (table by table) , after that you could dump tables in csv format and import them in fb

ps: there are better tools for data pump (do a search on google and this forum )

I would recommend
http://www.clevercomponents.com/pro.../ibdatapump.asp
or
http://www.ibphoenix.com/main.nfs?a...ql2gdb&o=Search

Enjoy

--
Best regards,
Fikret Hasovic http://fikret.fbtalk.net
TAMP R&D Team
FirebirdSQL Foundation member.
- Join today at http://www.firebirdsql.org/ff/foundation
JEDI VCS contributor
http://jedivcs.sourceforge.net/

Please take a look at FullConvert application. It can convert many database formats, with closest possible structure preserved. It transforms indexes, too, and is very fast. There are also some advanced functions which enable you to edit target database and store your actions in session file for easy reuse.

URL: URL

Damir Bulic
Spectral Core
URL

Firebird has a tool called qli which exists on all platforms (windows, linux, etc). You can view the documentation here:
QLI Syntax

It supports GDML (if you know it) so that you can export/import all you data into separate files.

In MySQL, you can do things like the following to export
SELECT a,b,a+b INTO OUTFILE '/tmp/result.text'
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\n'
FROM test_table;

and you can use the mysqlimport utility to import.

So, you don't have to buy anything, and you'll have a whole lot of fun migrating databases.

Dan.

Take a look at Database Workbench: www.upscene.com - it has both schema converters (tables, indices etc) and a DataPump tool.