Thursday, September 10, 2009

Import MYSQL Data to Microsoft SQL Server 2005

At times you my need to interact with mysql database and the method given below is very easy for Microsoft SQL Server guys to do stuff with mysql database.

1) You need to have a mysql instance configured.
2) Install the MySQL ODBC Driver for Microsoft SQL Server
3) Add MySQL Instance as a linked server to Microsoft SQL Server by issuing the mentioned below command.
4) Access and Import you MySQL Data right from Microsoft SQL Server Management Studio