I have a MySQL 5.5 database that I wish to migrate to Firebird Server 2.5. I have no issues with an existing MySQL database but after MySQL's acquisition, I am worried about the unavailability of Community Edition any time soon.
I want to migrate to a true and robust RDBMS like Firebird. PostgreSQL 开发者_StackOverflowis another choice, but it's .NET provider is sluggish.
Is there any free tool to migrate existing MySQL database to Firebird? I also want to know how Firebird fits in terms of performance when compared with MySQL.
I have used Clever Components' Interbase DataPump with success. I personally haven't used it with MySQL, but there shouldn't be any problems.
As of perfomance comparison - as always it comes down to your specific data and use cases. General wisdom is that MySQL is faster in some cases but it comes with the cost of reliability (ie not using transactions).
I also use Clever Components Interbase DataPump but you can also check IBPhoenix ressource site here
精彩评论