Link to home
Start Free TrialLog in
Avatar of Matthew B
Matthew BFlag for Canada

asked on

Mysql Migration Wizard Error

Migrating from MSSQL to mysql using migration wizard (specifically from MSSQL Azure hosted DB).

WHen i connect with mysql workbench migration wizard, the schema is blank, and it cant find the related database and or tables to be imported to mysql.

 I used an alternative software called Data Loader -- https://www.dbload.com/
and it worked perfectly, found the schema on my first try.

I have to purchase this software -- 99 bucks, but i would prefer not too. Does anyone know why MySQL doesnt work finding the schema but this software that looks like its from 1990s works?

If the data loader app works it cant be permissions or user account because im using all the same.
Avatar of noci
noci

you may get more meaningful errors when using the low level tools like:

/usr/bin/wbcopytables-bin --help
( --help show the options it has)

wbcopytables-bin  is setup on my system in /usr/bin, it might also be in some mysqlworkbench directory under /usr/share or /usr/libexec...)

find / -name 'wbcopytables*'  
will tell you where it is.
This question needs an answer!
Become an EE member today
7 DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.