1, write their own procedures, the method is relatively troublesome, but relatively flexible processing, if the conversion of data to be processed, using this method is more appropriate, this method is not suitable for large data migration, not only inefficient, but also need more memory;
2, through BCP export TXT or CSV format, and then import on the MySQL side; This method can only process one table at a time, but can be written as batch processing, this approach may encounter coding problems, not recommended;
3, through the function of the export provided by MSSQL to migrate, need to install MySQL ODBC, the specific process is not introduced, I recommend this method, the transfer of data will not appear chips and other issues (target database encoding can be formulated), and do not need to build tables on the MySQL side, MSSQL will automatically build tables and import data, the only bad thing about this method is slow.
Several ways to migrate MSSQL to MySQL