Description:
Hi, hope you guys are doing well.
I am using the *MySQL Workbench 6.3 CE* and MySQL Server is *5.5.53* and i am migrating few databases from SQL Server to MySQL. I have successfully migrated all my databases but now getting in last database which is in large size. I have migrated all it's tables one by one and now getting an error while migrating the last tables.
I am getting the following error message:
*** ERROR: Copy helper exited with an error: Worker exited with status -1073740940
Data copy results:
- `CPAReview`.`QuestionContent_3000_1` has FAILED (2100 of 3000 rows copied) ***
As i have migrated around 10 databases and as far as my understanding this is due to the large size of this table. When i tried ti migrate only 2000 rows then it worked, but when i go far more than 2000 rows it show this error message. I have around 25 millions rows in this table so it will be impossible to migrate all data in chunks of 2000.
So please let me know the solution to this problem. Thanks in advance !
How to repeat:
Start migration wizard and try to migrate a large table from SQL Server to MySQL, the tables needs to have multiple ntext fields in sql server that will be converted to largetext in MySQL....
Suggested fix:
I think this is not a bug, i just don't know to solve this
