PDA

View Full Version : Convert MySQL to Postgres



zackf
21st January 2009, 05:28 PM
Has anyone used a reliable tool that converts mysql databases to postgres?

soker
21st January 2009, 07:13 PM
you mean the sql code or the .mdb files ...?

zackf
21st January 2009, 07:17 PM
Yes the mdb files, we are using mysql and it's been recommended we switch to postgres SQL. I am just trying to figure the best way to do it.

ppesci
21st January 2009, 07:23 PM
The best way I know to do it is exporting the db with mysldump and then importing via batch in postgres. Mya be you need to edit the resulting file because mysql can have some non standard features or maybe there is type incompatibilities.

HTH

ppesci
21st January 2009, 07:23 PM
The best way I know to do it is exporting the db with mysldump and then importing via batch in postgres. Mya be you need to edit the resulting file because mysql can have some non standard features or maybe there is type incompatibilities.

HTH