MySQL ODBC for MySQL and SQL Server conversion

Source: Internet
Author: User
Tags copy dsn odbc sql mysql mysql in mysql database

Converting a MySQL database to a SQL Server database, or converting a SQL Server database to a MySQL database, is often used in NT environments. Using MySQL ODBC is easier, you can use the SQL Server7 management tools, you can use the MySQL management tools, you can use other party management tools. Here is a way to use SQL7 MMC, the SQL Server7 data into a MySQL database, the source and the purpose of the contrary, you can convert MySQL database into a SQL Server7 database.

1, the installation of MySQL ODBC interface.

2, the establishment of MySQL DSN, you can build System DSN, here named Testmysql, fill in ip,dababase, user name password, etc., complete.

3. In SQL7 MMC, select the database you want to export, and right-click the all Tasks->export Datas.

4. Start DTS Export wizerd:

Choose a Data source:microsoft OLE DB privoder for SQL Server

Server: Servers for your SQL Server7 database

Whether to use NT Authentication and username password look at your own. Finally choose a database, such as: Mynews (you want to lead to MySQL in the databases).

5, Choose a destination: choose MySQL:

User/system DSN, if established, select, if not established, new.

6. Specify Table Copy or Query:

Copy table (s) from the source database, starting from the copy tables

7. Select Source Table:

Select the table you want to copy, and if you don't want to make a careful adjustment, choose all of them.

8, run immediately, of course, to execute immediately, the next choice is completed, the conversion began.

This conversion is sometimes a part of the table may fail, double-click the failure of the table to see what the reason, generally SQL7 data type problems, make some small changes should be able to.



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.