MySQL to PostgreSQL

[Maggie McPherson]

Hello

My question is how can I convert MySQL database to PostgreSQL in Linux? Actually I've a big MySQL database containing tens of tables that I need to convert in to PostgreSQL. I've tested some of old Perl scripts but none of them did the job properly. So I was wondering if there is any free and efficient tool or script which you have tried and actually does the conversion with the least hassle.

[dWight]

Did you try: mysqldump –compatible=postgresql yourdabase >dump.sql , however you will a lot of information on the Google regarding to this issue.