Recommended tools for converting SqlServer to Mysql (mss2sql)

Source: Internet
Author: User
The tool that a friend sent me a few days ago was quite good. Share and record it for future use. Tool Name: mss2sql. The following procedure is provided: 1. Download the tool first. The tool will be decompressed at the bottom of the log. 2 options are available:

The tool that a friend sent me a few days ago was quite good. Share and record it for future use. Tool Name: mss2sql: 1. First download the tool (provided at the bottom of the log) 2. decompress the tool and run mss2sql.exe with two options. Here I select the first item:

The one that a friend sent me a few days agoToolsIt seems pretty good to use it.

Share and record it for future use.

ToolsName: mss2sql

Procedure:


1. DownloadTools(Provided at the bottom of the log)


2. decompress the package


3.run mss2sql.exe


There are two options in total. Here I select the first option: directly move to the Mysql server


4. Next step:


Fill in the link information of SQL Server. Here I use "." (click) to directly connect to the local windows login mode. If the remote Server is used, enter the IP address, user name, and password.


5. Next Step


Enter the link information of Mysql, and Access mode (Access mode, I will select Local here). If it is imported to a Remote host, select Remote ), then fill in the mysql login account and password. (For remote hosts, enter the following Host, Port number, IP address, and Port number respectively)


6. Next Step


Select the SQL ServerConversionDatabase, you can selectConversionTable definition and skippingConversionIndex. SelectConversionTest Database.


7. Next Step


Select the requiredConversionFor tables in the past, Add all (all) is generally selected. Here I only have one table Table_1 for testing.

Then,ConversionProgress bar. After the progress bar is completeConversionComplete.



Let's go to Mysql and see:


Complete ~ The data in my table is an image and the drop is not displayed on the dos interface ...~~


Tools: Http://download.csdn.net/detail/Andrew_wx/3645659

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.