Use MySql ODBC for data conversion between MYsql and MSsql

It is often used in the NT Environment to convert a Mysql database to a MSsql database or to a Mysql database. It is easy to use MySql ODBC. You can use MSSQL7 management tools, mysql management tools, and other management tools.
Here we will introduce a method of using MMC of SQL7 to convert data from MSsql7 to a Mysql database, and convert the source and target data to a database of Mssql7.

1. Install Mysql ODBC interface, which can be downloaded from this site
2. Create a DSN for Mysql. You can create a system DSN. Name testmysql here, enter the IP address, dababase, and username and password.
3. In MMC of SQL7, right-click the database to Export and choose All Tasks> Export Datas...
4. Start DTS Export Wizerd ...,
Choose a Data Source: Microsoft ole db Privoder for SQL Server
Server: the server of your MSsql7 database
Whether to use NT authentication and user name password to check your own
Finally, select a Database, for example, mynews (you need to import the Database to mysql)
Next Step
5. Choose a Destination: Select Mysql
User/System DSN. If it has been created, select it. If it has not been created, create it.

6. Specify Table Copy or Query
Copy table (s) from the source database, starting from copying a table from the source database
7. Select Source Table
Select the table to be copied. If you do not want to adjust it carefully, select all.

8. Run immediately. Of course, you need to execute it immediately. After the next step is selected, the conversion starts.

Sometimes some tables may fail to be converted. Double-click the failed table to see what the cause is. This is generally due to the data type problem of SQL7. Make some minor changes.

It is easy to use MySql ODBC. You can use MSSQL7 management tools, mysql management tools, and other management tools.
Here is a method for using MMC of SQL7.
1. Install Mysql ODBC interface, which can be downloaded from this site
2. Create a DSN for Mysql. You can create a system DSN. Name testmysql here, enter the IP address, dababase, and username and password.
3. In MMC of SQL7, right-click the database to Export and choose All Tasks> Export Datas...
4. Start DTS Export Wizerd ...,
Choose a Data Source: Microsoft ole db Privoder for SQL Server
Server: the server of your MSsql7 database
Whether to use NT authentication and user name password to check your own
Finally, select a Database, for example, mynews (you need to import the Database to mysql)
Next Step
5. Choose a Destination: Select Mysql