MySQL ODBC for MySQL and SQL Server conversion

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.