Mysql database architecture and data transfer to sqlserver

Source: Internet
Author: User
Download architecture Conversion Tool: mysql to mssql (mysqltomssql) 4.3: www.pc6.comsoftviewSoftView_56644.html after conversion, the longtext data in mysql will be garbled and this tool does not have the character setting function. After the architecture is switched, check the data. If there is any garbled code, delete all the data. However

Schema Conversion Tool download: mysql to mssql (mysql to mssql) 4.3: After the http://www.pc6.com/softview/SoftView_56644.html to mysql longtext data will appear garbled and this tool does not set the character function. After the architecture is switched, check the data. If there is any garbled code, delete all the data. However

Download the architecture Conversion Tool:

Mysql to mssql 4.3

: Http://www.pc6.com/softview/SoftView_56644.html

After conversion, the longtext data in mysql will be garbled and the tool does not have the character setting function.

After the architecture is switched, check the data. If there is any garbled code, delete all the data.

Use the Navicat for mysql tool to right-click a table with garbled characters and then click Export wizard above to export it as an access database file.

Then import data from access to sqlserver in sqlserver. errors may occur. All errors I encounter are constraints. Check the columns that report errors and change the column that cannot be null to null. Then all the data is deleted again and imported again until the import is successful.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.