Subject Re: [firebird-support] Tools to migrate from MySQL to Firebird
Author Ann Harrison
On Wed, Jan 18, 2012 at 12:13 PM, Rohit <code1008@...> wrote:
> 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,