The database is migrated from MySQL to MSSQL due to project needs. Use the tool Ssma for MySQL (provided by Microsoft).
: https://www.microsoft.com/en-us/download/details.aspx?id=42657
1. After downloading installs the Ssma, needs to use the authorization file, the authorization file Baidu can.
2. Need to install MySQL ODBC driver,mysql official website download
3. Open the software and create a new project connection for MySQL and SQL Server
4. Select the MySQL database that needs to be moved out, and right-click Generate report to generate the corresponding migration report. The error message is clear. If there is an error, you need to dispose
5. Select the MySQL database you want to move out, and right-click to generate the schema.
6. Select the MSSQL database that needs to be moved in and right-click to synchronize Database
7. Select the MySQL database you want to embed and right-click to migrate Data
Get
MySQL migration to SQL Server