Friday, June 18, 2010

Migrate MySQL to MSSQL

EXEC master.dbo.sp_addlinkedserver
@server = N'teste_dsn',
@srvproduct=N'test_db',
@provider=N'MSDASQL',
@provstr=N'DRIVER={MySQL ODBC 5.1 Driver}; SERVER=localhost; _
DATABASE=test; USER=root; PASSWORD=root; OPTION=3';



SELECT * INTO test.dbo.lookup_master
FROM openquery(test_dsn, 'SELECT * FROM test_db.lookup_master');

No comments:

Blog Archive