MySQL数据库导入到SQL Server

  EXEC master.dbo.sp_addlinkedserver
@server = N'MYSQL2',
@srvproduct=N'mySQL',
@provider=N'MSDASQL',
@provstr=N'DRIVER={MySQL ODBC 5.3 Unicode Driver}; SERVER=localhost; _
 DATABASE=testdb; USER=root; PASSWORD=; OPTION=3'

  SELECT * INTO xm
FROM openquery(MYSQL2, 'SELECT * FROM testdb.testtb)

MySQL数据库导入到SQL Server
http://blog.csdn.net/caijing3210/article/details/7238953