Is there an efficient and free method of migrating a 6GB Interbase DB to MySql?

Question

That's about it. I can always just dump it to csv and read it in, but I was hoping to avoid that.

Answer 1

Since both Interbase and MySql have ODBC drivers, how about using your favorite development environment to write an app that opens each table in the IB database and copies it into the MySql database? There are various languages and IDE's that support data access using odbc.

This would be nicer than using csv because your code could copy the schema during the process of copying each table.

Answer 2

You can use Database Workbench

Cross database development

Use the Schema Compare and Migration Tools to compare testing and deployed databases, migrate existing databases to different database systems.

ps: I don't know why you want to migrate from Interbase to MySQL but you can also take a look to Firebird