debugsqlMinor
Why SQL Server Migration Assistant keeps crashing on the 'Migrate Data' step?
Viewed 0 times
whycrashingmigrationkeepsthesqlassistantmigratestepserver
Problem
I'm trying to migrate a MySQL database to SQL Server using the SQL Server Migration Assistant for MySQL. Converting the schema and synchronizing with SQL Server works fine.
However, after clicking the Migrate Data button, SSMA crashes after a few seconds (SSMA has stopped working). What might be the cause of this problem?
However, after clicking the Migrate Data button, SSMA crashes after a few seconds (SSMA has stopped working). What might be the cause of this problem?
Solution
One more thing that helped me in addition to setting affinity to
SSMA stopped crashing after I set Parallel Data Migration Thread Count to 1.
You can find it in
My current version is 7.0.0, MySQL ODBC Driver version is 5.3.6.
Core 0 only:SSMA stopped crashing after I set Parallel Data Migration Thread Count to 1.
You can find it in
Tools > Project settings > Genaral > Migration (in the left pane) > Parallel Data Migration. Set Parallel data migration mode to Custom and then Thread count to 1.My current version is 7.0.0, MySQL ODBC Driver version is 5.3.6.
Context
StackExchange Database Administrators Q#133651, answer score: 6
Revisions (0)
No revisions yet.