Is there a simple tool to convert mysql to postgresql syntax?

Question

I've tried the tools listed here, some with more success than others, but none gave me valid postgres syntax I could use (tinyint errors etc.)

Answer 1

Have a look at PG Foundry, extra utilities for Postgres tend to live there. I believe that the tool you're looking for does exist though.

Answer 2

How large is your database? What's stopping you from just writing in the SQL code since most of it is going to be the same anyway? Could we get some more information please?

Answer 3

you will most likely never get a tool for such task which would do all of your job for you. be prepared to do some refactoring work yourself.

Answer 4

There is one piece of pay software listed on this postgresql page: http://www.postgresql.org/download/products/1

and this is on pgFoundry: http://pgfoundry.org/projects/mysql2pgsql/

Answer 5

There's a mysqldump option which makes it output PostgreSQL code:

mysqldump --compatible=postgresql ...

Answer 6

Thanks for the answers. None of the free options worked for me, the generated sql always causes errors.

I'm suprised. Are the syntaxes so different? I know postgres has more features, but even simple snippets for creating tables + columns fail.