MySQL Forums
Forum List  »  PostgreSQL

Advanced Search
New Topic

Whats the easiest way to migrate table data from Postgresql to MySql?
Posted by: david.launen
Date: February 20, 2006 01:46PM

I'm looking to migrate the data from my Postgresql db to MySql. I've tried the Migration Tool, was able to connect, and view all the tables etc. however the migration fails with similar problems that others have reported.

I can easily create the database schema using Hibernate, however, I'm looking for the easiest way to get the data from the one database to the other. Does anyone have any previous experience and/or pointers of how to perform such a task?

The database is small with only ~50 tables, and one simple trigger.

Thanks.
David

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Whats the easiest way to migrate table data from Postgresql to MySql?
12645
david.launen
February 20, 2006 01:46PM
Re: Whats the easiest way to migrate table data from Postgresql to MySql?
8674
Francis Lee
June 19, 2007 07:57AM
Re: Whats the easiest way to migrate table data from Postgresql to MySql?
9596
Tso Tsalagi
December 13, 2007 04:13PM


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.