[MySQL] SQL Server migration to MySQL method introduction

First, the principle:

Only the table structure and data are migrated, and stored procedures, functions, triggers are rewritten as much as possible and fully tested.

Before migrating, set up some parameters of the database, such as default storage engine, default encoding, etc., to facilitate subsequent import.

second, the method:

1. Using MySQL Workbench

MySQL Workbench provides the migration Wizard (Database Migration) feature to support the data format of MSSQL into MySQL data formats;

Refer specifically to this article: http://mysqlworkbench.org/2012/07/migrating-from-ms-sql-server-to-mysql-using-workbench-migration-wizard/

If there is not a enough memory to allocate insert buffer of size 1073741824, please Google resolve. may be the MySQL side max_allowed_packet, key_buffer_size size setting problem.

The solution for the blogger is to create a new MySQL database on the Windows machine as an intermediate import library. Then synchronize the data between the two MySQL libraries.

Attention:

1) Look at the log file Wb.log error, copy the results of this log prevail.

2) source Rmbms connection parameter, server fills in SSMs after that name (general-name).

2. Using Navicat Premium--I recommend

Navicate provides the ability to transmit data, which can be used as an intermediary operation node to copy a database to another library.

Simple operation, the general interface to select the libraries and tables to be synchronized, the advanced interface to remove the creation of the index, check the error continue, other basic default.

Pay attention to the log after completion, if there is an error not to copy the data, please resynchronize these tables, and in the high-level hook using the full INSERT statement,

So we can see the SQL statements in the log and manually perform the insert and debug errors. Table is not synchronized, please manually build the table.

third, follow-up operation:

1, manually rewrite the stored procedures, functions and triggers, and to pass the program to fully test the inspection.

2, according to business needs, add the appropriate index.

Attached: Two different methods: https://www.percona.com/blog/2016/06/23/migrate-from-ms-sql-server-to-mysql/

[MySQL] SQL Server migration to MySQL method introduction