current community

more stack exchange communities

Stack Exchange
tour help
Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 1 down vote favorite

Is there any command line tool for converting the MySQL database to PostgreSQL? I'd also like to know if there is a way to convert the database using the normal mysqldump command.

share|improve this question
 
Start here: wiki.postgresql.org/wiki/… –  a_horse_with_no_name Mar 29 '12 at 6:37
 
Whenever I see this, I cry tears of joy. –  rfusca Jul 27 '12 at 16:01
add comment

3 Answers

up vote 1 down vote

have you tried:

mysqldump --compatible=postgresql dbname > export.sql

then do this to escape quotes

sed "s/\\\'/\'\'/g" export.sql > export1.sql

may need some more massaging so look at mysqldump doco more closely.

share|improve this answer
 
I have tried the method given by you already but it is giving error when restoring in the postgresql –  Mughil Mar 29 '12 at 11:58
 
@Mughil what is the error? –  Janus Troelsen Jul 29 '12 at 0:04
add comment
up vote 1 down vote

There is actually a free migration tool that's quite easy to use, developed by EnterpriseDB themselves. It can be installed via the StackBuilder: Migration Toolkit

share|improve this answer
add comment
up vote 0 down vote

I recently use a non-free tool from DBConvert to convert an access database to postgres, and found it well worth the money compared to the amount of time I wasted trying to do it reliably for free. The sell a similar tool for MySQL<->postgres, which I have not used, but may well be worth considering unless you are only interested in command line tools.

In case you are wondering I am not affiliated with them in any way :-)

share|improve this answer
add comment

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.