Search code examples
postgresqlmysql-workbenchdatabase-migrationpostgresql-8.1

Migration from PostreSQL to MySQL using MySQL Workbench trows errors


I am trying to migrate a PostreSQL database to a local MySQL server using MySQL Workbench. I have set both connections, tested them and succeded, selected schemas to migrate and clicked next.

However, it always ends up at Reverse engineer selected schemas, where it keeps getting some errors. The image(s) below shows them all.

I have found some suggestions to edit some files (db_postgresql_re_grt.py), but none of them worked (even after restarting MySQL Workbench).

PostgreSQL version is 8.1.23

Error

Complete message log: Message log


Solution

  • It seems you found a bug in migration wizard. Please fill bug report, and (if you can) attach your database to it (you can make it private, that only Oracle employees can see it).