Tools to migrate from MySQL to Firebird

[Rohit]

Hi Firebird Users,


I want a free tool to migrate an existing MySQL database to Firebird. Is there any tool?


Rohit K.
-------------





[Non-text portions of this message have been removed]

[Martijn Tonies]

Hi,

Post by Rohit
I want a free tool to migrate an existing MySQL database to Firebird. Is there any tool?

I do not know of a free tool, but you can try the Trial Version of
Database Workbench - see www.upscene.com - and convert
metadata.

With regards,

Martijn Tonies
Upscene Productions
http://www.upscene.com

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!

[Reinier Olislagers]

Post by Martijn Tonies
Hi,

Post by Rohit
I want a free tool to migrate an existing MySQL database to Firebird. Is there any tool?

I do not know of a free tool, but you can try the Trial Version of
Database Workbench - see www.upscene.com - and convert
metadata.
With regards,
Martijn Tonies

Additionally, there are datapump like tools around that work with e.g.
ODBC or JDBC connections and that let you copy data around.

I use e.g. SQLWorkbench/J to create non-existing tables in the target
database and copy/sync data....

As for automatically converting stored procedures etc, there's probably
no tools that can reliably do that as the databases are too different...

Regards,
Reinier

[Ann Harrison]

Post by Rohit
I want a free tool to migrate an existing MySQL database to Firebird. Is there any tool?

Several people have suggested data migration tools. Unless you've
been very disciplined or lucky, moving the data is going to be the
easy part. MySQL has a very casual relationship to the SQL Standard.
Firebird is much more compliant with the standard. As you begin
moving your schema, you'll find that some MySQL data types have no
Firebird equivalent. Enum is one that comes to mind. Time/Date data
is also problematic since MySQL allows dates that most other systems
(and the standard) disallow like zero February 2011. When you run
into differences between Firebird and MySQL, you'll get much better
answers here if you spend a few minutes googling the syntax you used
in MySQL to see if it's standard, then ask for a way to approximate
the MySQL behavior in Firebird rather than assuming that Firebird's
differences are deficiencies.

Good luck,

Ann

[Milan Babuskov]

Post by Rohit
I want a free tool to migrate an existing MySQL database to Firebird. Is there any tool?

I wrote a quick&dirty PHP script that works on SQL structure dump from
PHPMyAdmin:

https://github.com/mariuz/mysql2firebird

It's still rough and does not support all MySQL datatypes, but it's open
source, so you can modify it to fit your needs.

I also wrote a simple data-pump in PHP, let me know if your're
interested, I can put it for download as well.