Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I need often to convert a database from a database server to another, for example convert a database in MSSQL to a PostgreSQL or convert a MySQL to PostgreSQL, but also convertion between MySQL and Firebird.

Is there a good tool that allow to convert a database from/to different kind of database server ?

share|improve this question
add comment

2 Answers

up vote 0 down vote accepted

I've found some interesting converter, therefore i answer myself, maybe this tool could be useful to someone else :

  • ESF Database Migration Toolkit ( http://www.easyfrom.net/ ): This toolkit dramatically cuts the effort, cost, and risk of migrating to/from any of the following database/file systems: Oracle, MySQL, SQL Server, PostgreSQL, IBM DB2, IBM Informix, InterSystems Caché, Teradata, Visual Foxpro, SQLite, FireBird, InterBase, Microsoft Access, Microsoft Excel, Paradox, Lotus, dBase, CSV/Text and transfer any ODBC DSN data source to them.

  • Database Converter : A generic metadata, data, and progam migration tool for various databases.Create, review, and modify migration defition with/without database connectivity.Execute database migration or generate relevant SQL and data files as per user choice.

share|improve this answer
add comment

There is a very good page on the postgresql wiki regarding the conversion to postgresql.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.