Convert SQL Server to MySQL using the Mss2sql tool

Source: Internet
Author: User
Tags name database

Reprint: http://www.cnblogs.com/angestudy/archive/2012/06/04/2533548.html

Mss2sql:http://files.cnblogs.com/andrew-blog/mss2sql.rar

To open a compressed package after download

Run Mss2sql

The default is move to MysQL server directly, select Next

Go on, wait a minute.

This time it is necessary to connect to MySQL server, I am local, so choose Local, fill in your username and password

Continue waiting for connection

Select the database that needs to be converted in MS SQL

Click Next, if MySQL has the same name database, will let you choose the way to convert, respectively is

  • Overwrite the entire database: covering the entire data base
  • Overwrite existing tables only: Overwrite the existing table
  • Skip existing tables: Skipping tables that exist
  • Merge: Merging

My MySQL is just an empty database, so I chose the first item, the whole coverage.

Select the table to be converted, add to the conversion list, I need all the tables, so I chose the add all

Then there's a time to wait

There is not much data in this table, it takes a little longer, about 10 minutes, if the table is large, it may be faster to use the program to convert, there is a convenient way also please tell me

The following is the successful conversion of the table, the data inside the OK, Chinese is no problem.

Convert SQL Server to MySQL using the Mss2sql tool

Related Article

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.