MySQL Forums
Forum List  »  PostgreSQL

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

Options: ReplyQuote


Subject
Views
Written By
Posted
Whats the easiest way to migrate table data from Postgresql to MySql?
11979
February 20, 2006 01:46PM


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.