Issue while starting migration wizard in mysql workbench

user_12255631 0
Viewed 4445

I am trying to migrate from postgres to mysql database using mysql workbench. I have installed postgres into my system and its working fine.

When i start migration wizard and dependency error shows as,

Could not import the pyodbc python module. You need pyodbc 2.1.8 or newer or migrations from RDBMSes other than MYSQL.

then after ignoring this error when i actually start the migration process it shows me another error in log,

SystemError: ImportError("No module named pyodbc"): error calling Python module function DbPostgresqlRE.connect
ERROR: Error during Connect to source DBMS: ImportError("No module named pyodbc"): error calling Python module function DbPostgresqlRE.connect
ERROR: Exception in task 'Connect to source DBMS': SystemError('ImportError("No module named pyodbc"): error calling Python module function DbPostgresqlRE.connect',)

After googling a bit I reinstalled or newly installed few things, but it did not work as the same error popups every time. I tried renaming the python file , dll file , manually copied installed pyodbc.py, installed different versions of python but still the same.

how to resolve this issue ?

database-migration mysql-workbench migration postgresql mysql
1 Answers

Had the same issue

  1. Try to install MySQL Workbench with lower version, e.g. 8.0.20. (It's easy with MySql Installer)
  2. Find file "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\python\site-packages\pyodbc.pyd" and save it.
  3. Then upgrade MySQL Workbench to the latest (in my case 8.0.22)
  4. Copy previously saved file pyodbc.pyd back to the "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\python\site-packages"

Please leave a comment if it works for you

user_12665220
Related