Author Topic: Fix for DB migration/transfer process from Qube 6.x to 7.x (MySQL to PostgreSQL)  (Read 308 times)

shinya

  • Administrator
  • *****
  • Posts: 229
Greetings, all!

We have discovered that the supervisor DB migration process from Qube 6.x to 7.x, from MySQL to PostgreSQL, can fail if the Qube 6.x supervisor has gone through upgrades.

We have patched the export_data_from_mysql.py script, and also added an additional required SQL script, fix_mysql_column_orders.sql, and made them available
for download on our "db_migration_tools" download page at http://repo.pipelinefx.com/downloads/pub/db_migration_tools/ .

If you're having difficulty importing the data into PostgreSQL, please (re-)download both of these files and start over with the updated instructions available at:
http://docs.pipelinefx.com/display/QUBE/Transferring+data+from+MySQL+to+PostgreSQL