Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have to migrate a MySQL database to PostgreSQL. I have tried the mysqldump with --compatible = postresql. I have seen that some poeple use ETL like Talend to make the migration but you must describe the migration for all tables... (I have 39 tables...)

Any other idea ?

Thanks in advance

share|improve this question
My team is using Talend. I know it's a good option but I don't think its free. – djangofan Nov 13 '13 at 17:38
up vote 2 down vote accepted

Create the tables by hand, and then script the data inserts with Perl/PHP/Python/etc, and just run through the data, preferably using PDO (to get around Pg's issues with BLOB data).

share|improve this answer
Probably the easiest way if mysqldump wasn't able to produce anything usable. Leave out all indexes and constraints until AFTER you load your data to make life easier: You won't have to unwind the dependencies & you'll save lots of time if you're not updating indexes on every insert. – voretaq7 May 27 '10 at 15:05
Nothing automatic ??? – hotips May 28 '10 at 9:42

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.