MSSQL migrated to MySQL

I tried to use the company's database byMSSQL migrated to MySQL, get a bit of experience Rumor: Migrating a relational database to a non-relational database is simple, but migrating a non-relational database to a relational database is very difficult. Select tool:

Tried sqlyog, found the configuration is also very troublesome.

Finally, I chose. Navicat Premium

Advantages:

1. Simple visualization of operation;

2. available for MSSQL,MySQL,Oracle,MariaDB , PostgreSQL database to operate;

3. for the table structure to replicate accurately, you can copy indexes, foreign keys

4. copy data very fast 10000/ seconds, low error rate

Disadvantages:

1.MSSQL calculation field will be error when migrating, can be implemented with import and export (Low efficiency 700/s)

2. It is not clear whether other tools can migrate functions, stored procedures, this tool does not implement

3. Unable to migrate views

replication process:1. Select the tables you want to copy, and pull to the list of tables that require the target library.

650) this.width=650; "src=" Http://s2.51cto.com/wyfs02/M02/78/A5/wKioL1aA042RZaAWAABbOsPxQjc486.png "style=" float: none; "title=" Image 1.png "alt=" Wkiol1aa042rzaawaabbospxqjc486.png "/>

2. Configure the import file

650) this.width=650; "src=" Http://s1.51cto.com/wyfs02/M02/78/A6/wKiom1aA03SQ4K2CAABIS_npokg201.png "style=" float: none; "title=" Image 2.png "alt=" Wkiom1aa03sq4k2caabis_npokg201.png "/>

3. Click Start to perform the copy

650) this.width=650; "src=" Http://s1.51cto.com/wyfs02/M00/78/A7/wKiom1aA03WRdSBqAABvVmaGnpA240.png "style=" float: none; "title=" Image 3.png "alt=" Wkiom1aa03wrdsbqaabvvmagnpa240.png "/>

4.Finish ClosingImport / export Process It's interesting to try.Note:

1. to choose the encoding when importing:936 (ansi/oem-simplified Chinese GBK), otherwise Chinese will be garbled

2. field names are truncated when importing

This article is from the "Sukun" blog, make sure to keep this source http://sukunwu.blog.51cto.com/10453116/1729121

MSSQL migrated to MySQL