I have a MySQL datadump file from the database to be moved. From the suggestions I've read so far, most migration tools only work with databases that are hosted on the same server. What steps can I take to convert the MySQL datadump file to an SQL Server database on a separate machine?
Use Microsoft SQL Server Migration Assistant for MySQL to migrate data from MySQL into SQL Server.
The steps involved consist of:
Mout/Restore/Load the datadump file to a new MySQL server.
Use SSMA for MySQL to migrate to SQL Server. SSMA does not require MySQL to be installed on the SQL Server machine, however it requires a running database engine to communicate with.