5

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?

tinlyx
3,84014 gold badges50 silver badges79 bronze badges
asked Mar 29, 2016 at 12:12

2 Answers 2

6

One more thing that helped me in addition to setting affinity to 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.

Andriy M
23.3k6 gold badges60 silver badges104 bronze badges
answered Oct 28, 2016 at 0:29
1
  • Interesting, didn't found this option earlier. Commented Oct 28, 2016 at 6:26
5

On some certain conditions, SSMA seems to cause problems when using it on a multi-core machine.

I opened the Task Manager and set SSMA's processor affinity to Core 0 only. This fixed the crash and I was able to migrate the whole database.

answered Mar 29, 2016 at 12:12
1
  • This fix also applies to the SSMA for Access (confirmed on version 18.8, the latest version as of today) Commented Apr 12, 2021 at 5:18

Your Answer

Draft saved
Draft discarded

Sign up or log in

Sign up using Google
Sign up using Email and Password

Post as a guest

Required, but never shown

Post as a guest

Required, but never shown

By clicking "Post Your Answer", you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.