up vote 0 down vote favorite

I am looking for a script to convert a ~1GB Mysql dumped database containing dozens of tables to Postgresql under Ubuntu. I have tried a couple of suggestions but they were kind of outdated and/or buggy. There is also a Ruby app, but I had difficulty installing RVM stuff. So I really appreciate it if you could point me to a script (in Perl, Python, Bash or whatever) which you have tried and actually does the job.

share|improve this question

1 Answer

up vote 1 down vote

You can convert the database directly with a database conversion tool rather than dumping data and then trying to import it.

Take a look at ESF Database Migration Toolkit for example .

share|improve this answer
Thanks for the suggestion. Is it Windows-only? Have you tried it yourself? – qliq Jan 1 '12 at 19:38
Yes i have tried it, and it works well. It works only on Windows, but if you need something platform independent take a look at opendbcopy ... – aleroot Jan 1 '12 at 19:40
Unfortunately I had no luck with either of these, probably because Java and Windows are alien to me. So need to look further. – qliq Jan 1 '12 at 22:08

Your Answer

 
or
required, but never shown
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.