Http://hi.baidu.com/luck001221/item/cb4462299f9ea79ab73263d2? Qq-pf-to = pcqq. group
1. Go to the mysql official website to download an odbc driver. Because MSsql has never been integrated with the mysql driver, this tool needs to be downloaded separately and installed.
Http://dev.mysql.com/downloads/connector/odbc/5.1.html
I downloaded the windows decompressed package Without installer (unzip in C: \) and did not choose to install it. The green version is better than the installation version. Click a bat file in install.
2. If the installation is successful, there is an option in the ODBC data source driver, for example:
3. Click the user dsn to add a mysql connection, provided that you have a mysql database.
The following prompt box is displayed after double-clicking:
Ah, ha, half done.
4. If DTS is used for SQL server2000, it can be used directly. The key steps are as follows:
The following interface is very familiar:
OK is imported.
Of course, you can also use the File dsn to save the connection string as a file, and then select the file dsn during import. You only need to find the path of the connection string ..
5. If you are using SQL2005 ssis, it is a bit disgusting. Here I want to emphasize:
I hate data transmission in sql2005. I hope Microsoft can see it.
The dsn here needs to be manually written and cannot be directly read from odbc. This function is very practical and will not cause many misunderstandings. But there is no such thing in 2k5. It's hard to understand why Microsoft's guys eat it.
Don't think you have succeeded. Click Next. Click Next. Wait.
You can only select-write a query to specify the data to be transmitted. Vomiting blood .. There are more than 200 tables. What about tmd?
After testing, neither the file dsn nor the system dsn Selects all the tables. If the file dsn is selected and the connection string is used, this error is reported:
I hate the DTS function of SQL Server 2005 very much. It is an idiot to design engineers of Microsoft SQL Server.
I decided to use 2 K.
I tested 2008, huh. 2008 this function is available ,:
Migrate data from SQL Server to MySQL
Http://www.cnblogs.com/gaizai/p/3237907.html
I,Background
II,Transfer Data