MySQL Forums
Forum List  »  PostgreSQL

Re: PostgreSQL -> MySQL...impossible?
Posted by: Mike Lischke
Date: March 30, 2006 01:55AM

Hong Man wrote:

> I have spent hours on the net looking for a
> solution to convert a PostGreSQL databse to MySQL,
> and came up blank. The psql currently sits on a
> Linux box running SuSe, and the MySQL sits on A
> Windows machine.

PostgreSQL has a JDBC driver => http://jdbc.postgresql.org/, MySQL Migration Toolkit can migrate any database that has a JDBC driver => http://dev.mysql.com/downloads/migration-toolkit/1.0.html.

Now do 1 + 1 :-)

Disclaimer: I have never migrated a PostgreSQL database to MySQL so I don't know what special requirements are necessary. As always, a 100% automatic migration is not possible. There is always some manual work or even no way (e.g. certain stored procedures from Oracle).

Mike

Mike Lischke, MySQL Developer Tools
Oracle Corporation

MySQL Workbench on Github: https://github.com/mysql/mysql-workbench
On Twitter: https://twitter.com/MySQLWorkbench
On Slack: mysqlcommunity.slack.com (#workbench)
Report bugs to http://bugs.mysql.com
MySQL documentation can be found here: http://dev.mysql.com/doc/refman/8.0/en/

Options: ReplyQuote


Subject
Views
Written By
Posted
16809
July 15, 2005 06:52AM
8070
October 11, 2005 11:19AM
8093
December 20, 2005 11:32AM
7875
February 16, 2006 05:00PM
Re: PostgreSQL -> MySQL...impossible?
8624
March 30, 2006 01:55AM
8449
April 09, 2006 10:42AM
9563
August 04, 2006 08:47PM
6536
November 21, 2006 10:46AM
6106
November 26, 2006 11:10PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.