Migrate from Postgrsql to Mysql

Posted March 6th, 2008 by yurangyuhan

I am about to migrate DB from Postgresql to Mysql.
During searching about migration, I found this site. and it is helpful to me.
How do I migrate DB from Postgresql to Mysql using Datatools (Data DownLoader from PostgreSQL and Data Uploader to Mysql)?

Does anyone who know how to migrate DB from Postgresql to Mysql?

I will appreciate your any opinion!

‹ Convert from Excel to SAS dataset Connecting ACT Premium 2008 with Excel... Is it possible ›

RE: Migrate from PostgreSQL to MySQL

On March 7th, 2008 jterrell said:

Hi yurangyuhan,

The Data UpLoader to MySQL includes many source adapters/connections, including a connector for PostgreSQL. Therefore, to migrate data from PostgreSQL to MySQL, you only need the Data UpLoader to MySQL (and an installed and properly configured ODBC 3.5 driver for MySQL on the workstation where DataTools is installed).

And the best part is that the Data UpLoader to MySQL can create tables in MySQL -- as long as the MySQL database instance exists. So for each table in PostgreSQL the Data UpLoader to MySQL will create a table in your MySQL database, including automatically resolving data type differences between the source and target databases (such as date/time and numeric fields), so the schema of each MySQL table is created for you, and the data is inserted into MySQL.

- Jo