I'm trying to migrate my database which is in MS SQL Server to MySQL, I'm using Workbench to do so. I get connection to both databases but get the following warning:
Retrieve schema list from source.
And this is the message log:
Starting...
Connect to source DBMS...
- Connecting to source...
Connect to source DBMS done
Check target DBMS connection...
- Connecting to target...
Connecting to Mysql@74.5.3.2:3306...
Connecting to Mysql@74.5.3.2:3306...
Connected
Check target DBMS connection done
Retrieve schema list from source....
- Checking connection...
- Fetching catalog names...
WARNING: The following catalogs where not found: Autotask
- Fetching schema names...
- Finished
Retrieve schema list from source finished
Tasks finished with warnings and/or errors, view the logs for details
Finished performing tasks.
Autotask is the name of the db. Please what am I doing wrong?
Note: even with the warning the wizard let me click next, but the next screen is supposed to list schematas, but as it is empty I can't continue.
Thanks in advance. Pablo
Make sure you're connecting to MS SQL as user "sa". Non-admin users may lack rights that are necessary to extract schemas...