MySqlMigrator is an intuitive and effective tool for MySQL to SQL Server data migration. It helps to transfer data from MySQL tables to existing SQL Server tables in a few easy steps.
The free trial version of MySqlMigrator can be used for evaluation purposes for two days after downloading. Also, it migrates 10% of rows per each table, but not less than 100 rows. To enjoy the full functionality of this product for an unlimited period of time, you must buy a license.
How to use the tool
Execute the MySqlMigratorSetup.msi file after it has been downloaded. During the installation, you should specify the folder for the program files and choose features to be installed. If you check “Launch MySqlMigrator when setup exits” during the installation, MySqlMigrator wizard will invite you to start the migration!
Many tables can be migrated as a part of a single migration task. The target SQL Server database and schema can be specified only once for the whole task.
The tool uses the bulk copy mechanism to load data from MySQL tables to SQL Server. This approach allows to achieve the maximum possible insertion speed.
Current migration tasks can be saved in a file and restored later. Thus, you don't need to specify all parameters from scratch when you are repeating the migration for a similar set of tables on the same servers.
The SELECT statement, which reads the source data, can be edited. This allows fixing many common data migration problems like incompatibilities in data type ranges and precision. It makes it possible to perform a partial data migration when you need to move only the records modified after a particular moment of time.
A wizard-like interface that allows the user to restart the migration from any step.
MySQLMigrator supports the following versions of database servers:
- MySQL 5.6
- MySQL 5.7
- SQL Server 2008R2 (10.50)
- SQL Server 2012 (11.0)
- SQL Server 2014 (12.0)
- SQL Server 2016 (13.0)
- SQL Server 2017 (14.0)
- Azure SQL DB 12.0
Select the source data provider
Using MySQLMigrator, on the very first step, you need to select the source MySQL data provider.
Connect to the source database
Then you need to provide the connection credentials so that MySQLMigrator can connect to the source MySQL database.
Connect to the target database
After providing the source database connection credentials, you need to specify the connection credentials for the target SQL Server database.
Specify the schema mappings
After connecting both to the source and target databases, you need to specify the schema mappings between the source and target objects.
Select the source tables
Then specify the source tables, which you want to copy from the source MySQL database to the target SQL Server database.
Save and execute
Finally, you can opt for executing the operation immediately or simply saving the package to run it later.