Description:
Attempting to migrate tables from MS SQL Server to MySQL using the MySQL Workbench Migration Tool on Windows 10 workstation supplies the following error message upon Bulk Data Transfer. I have noted issue occuring with prior versions of Workbench.
Starting...
Prepare information for data copy...
Prepare information for data copy done
Determine number of rows to copy....
Counting number of rows in tables...
wbcopytables.exe --count-only --passwords-from-stdin --odbc-source="DSN=SQL Server;DATABASE=;UID=INTOV8\steele.dale" --source-rdbms-type=Mssql --source-timeout= --target-timeout=None --table-file=c:\users\steele~1.dal\appdata\local\temp\tmpfuk0je
--table [Corvus] [ampla].[classifications]
15:44:48 [INF][ copytable]: --table [DB_Name] [Table_Name]
15:44:48 [INF][ copytable]: --table [DB_Name] [Table_Name]
15:44:48 [INF][ copytable]: --table [DB_Name] [Table_Name]
15:44:48 [INF][ copytable]: --table [DB_Name] [Table_Name]
15:44:48 [INF][ copytable]: --table [DB_Name] [Table_Name]
15:44:48 [INF][ copytable]: --table [DB_Name] [Table_Name]
15:44:48 [INF][ copytable]: --table [DB_Name] [Table_Name]
15:44:48 [INF][ copytable]: Opening ODBC connection to [Mssql] 'DSN=SQL Server;DATABASE=;UID=[User_Name];PWD=XXX'
15:44:49 [INF][ copytable]: ODBC connection to 'DSN=SQL Server;DATABASE=;UID=[User_Name];PWD=' opened
15:44:53 [ERR][ copytable]: Exception: SQLExecDirect(SELECT count_big(*) FROM [DB_NAME].[Table_Name]): 42000:1924:[Microsoft][ODBC SQL Server Driver][SQL Server]Database 'DB_Name' is already open and can only have one user at a time.
Loading table information from file c:\users\[User_Name]\appdata\local\temp\tmpfuk0je
ERROR: Determine number of rows to copy: Error getting row count from source tables, wbcopytables exited with code 1
Failed
Resuming...
Failed
Resuming...
Failed
How to repeat:
I have repeated this no matter how many tables are selected to migrate.
