2

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 ?

aleroot
  • 3,160
  • 5
  • 28
  • 37

2 Answers2

0

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.

Roddy
  • 280
  • 1
  • 4
  • 9
aleroot
  • 3,160
  • 5
  • 28
  • 37
0

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

Shadok
  • 623
  • 5
  • 10