views:

378

answers:

1

I saw couple of tools but all are paid, I have only one database in MySQL that we want to convert in MSSQL.

Suppose i create the schema by myself then is it possible to use OPENROWSET to open connection to mysql and import all data into sql with following statement?

INSERT INTO Customers 
   SELECT * FROM ( 
     OPENROWSET (
       'mysql',
       'mysql connection string',
       'SELECT * FROM Customers"))

or

OPENDATASOURCE?

+2  A: 

Maybe this information will be helpful for you: http://technet.microsoft.com/en-us/library/cc966396.aspx Also read the following: http://www.codeproject.com/KB/database/migrate-mysql-to-mssql.aspx

Sergey Olontsev