Database conversion

Contents:

Kettle can be used for database manipulation and conversion, but for some situations there are easier tools.

MySQL to PostgreSQL

mysql2pgsql converts a mysqlDump.sql file to a postgresDump.sql file. You then reload into psql. All datatypes are handled and there are 7 command line flags available.

Oracle to MySQL

50 things to know before migrating Oracle to MySQL

MS Access (MDB) to CSV/MySQL

MDB Tools can be used to export MS Access (MDB) to CSV. Through some simple scripting, you can import into MySQL with little trouble.

MDB2MySQL is another script to do the same. We haven't tested it, so let us know how you go with it :)


Creator: Sridhar Dhanapalan on 2008/05/26 04:37
XWiki Enterprise 1.7.2.16857 - Documentation