Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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

1 Answer 1

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

 
discard

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.