On Wed, Jan 18, 2012 at 12:13 PM, Rohit <[email protected]> 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, Ann
