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?