CODEWITHSUNDEEP
mysqldatabasedatabase-migration
iamdeed
iamdeed

Reputation: 390

How do I solve MySQL ERROR: Determine number of rows to copy: too many values to unpack Failed

In trying to migrate a MSSQL database using the MySQLWorkbench Migration wizard, I get the error message MySQL ERROR: Determine number of rows to copy: too many values to unpack Failed in the DATA MIGRATION stage precisely when its processing Bulk Data Transfer.

Upvotes: 1

Views: 770

Answers (1)

Sleiphan
Sleiphan

Reputation: 11

Does the name of your source database contain any special characters? Like in my case?

I got the same error as you, but fixed it by changing the name of the database to something simple, like mydatabase.

How to change the name of the database?

E.g. by using Microsoft SQL Server Management Studio. Right-click the database -> click "Rename", type the new name, and hit enter.

For some reason I had to do it by re-attaching the database, and specify the new name in the Attach As field inside the Attach Databases dialogue.

Why does this happen?

Looking at the log from my case, I suspect the problem to be caused by MySQL Workbench calling wbcopytables.exe with the argument --table {YOUR_DATABASE_NAME}, which in my case it used --table {C:\DATABASES\db.mdf}. It seems to be copying the source database name directly into the terminal.

Upvotes: 1

Related Questions