Data conversion for MySQL and MSSQL using MySQL ODBC

mysql|odbc| Data | conversion

Convert MySQL database to MSSQL database, or convert MSSQL database to MySQL database, which is often used in NT environment. Using MySQL ODBC is better, you can use the MSSQL7 management tools, you can use the management tools of MySQL, but also use other side of the management tools
This article introduces a method that uses SQL7 MMC, transforms the MSSQL7 data into MySQL database, the source and the goal conversely, can convert MySQL database into MSSQL7 database.

1. Install MySQL ODBC interface, you can download this site
2. Set up MySQL DSN, you can build System DSN, here named Testmysql, fill in ip,dababase, username password and other items, 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 MSSQL7 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)
Next
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 complete, start the conversion.

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.
Using MySQL ODBC is better, you can use the MSSQL7 management tools, you can use the management tools of MySQL, but also use other side of the management tools
Here's a way to use SQL7 MMC
1. Install MySQL ODBC interface, you can download this site
2. Set up MySQL DSN, you can build System DSN, here named Testmysql, fill in ip,dababase, username password and other items, 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 MSSQL7 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)
Next
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 complete, start the conversion.

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.