Migrating from MySQL to MS SQL

[Michael Feuti]

I have been tasked with migrating a legacy building monitoring system from MySQL to SQL server. I have tried unsuccessfully many times to use the the Microsoft SQL Server Migration Assistant for MYSQL. The migration always fails. I have increased every timeout option I can find and it has helped but it still fails. The reason is most likely that the is database is basically only two tables. One has about 50 million rows of data but the second has over 2 trillion rows of data. The connection does not stay open for some reason in the application and at most I get maybe 300million rows migrated.

Is there a better process to do this? I'm do not have a MySQL background but have a fail amount of SLQ knowledge. Any suggestions are most appreciated. Thank you.