MySql 5.6 for MSSql 2014 server migration: ExecuteReader requires an open and accessible connection

Question

MySql: 5.6 MSSql: 2014 Tools Used: SSMA for MySql

When migrating from mysql to mssql, all table and view structures were successfully migrated. When transferring data, the data was partially moved, and I received the following errors.

ExecuteReader requires an open and available Connection. The connection current state is closed.; SQL Server cannot access the source table <table-name> The connection has been disabled. 

There were other trivial problems, such as " Column" modified_on "does not resolve DBNull.Value. ", Which I fixed manually by editing the table structure.

Answer 1

To fix the Column 'modified_on' does not allow DBNull.Value , SQL Server Management Studio Column 'modified_on' does not allow DBNull.Value me to edit the structure. To do this, I had to change the configuration as follows.

Open SQL Server Management Studio -> Goto Tools -> Options -> Designers and uncheck the box "Prevent saving changes that require the Recreation table".

To resolve the following two problems:

 ExecuteReader requires an open and available Connection. The connection current state is closed.; SQL Server cannot access the source table <table-name> The connection has been disabled. 

Decision:

Open SSMA for MySql → Goto Tools → Project Settings → Select General in the menu on the left → Select Migration → In the Miscellaneous section -> set the data migration timeout in minutes = 500

Open SSMA for MySql → Goto Tools → Project Settings → Select General in the menu on the left → Select Migration → In the Parallel Data Transfer -> section, set the Parallel Data Migration Mode from Auto to User and set the number of streams from 10 to 5

Run the data migration again.

Hope this helps.