Friday, September 04, 2009

On USING SSIS to transfer data between SQL Server 2008 and MySQL

There are a large number of posts on various difficulties experienced while transferring data from MySQL using Microsoft SQL Server Integration Services. While the transfer of data from MySQL to Microsoft SQL Server 2008 is not fraught with any blocking issues, transfer of data from SQL Server 2008 to MySQL has presented various problems.

For data interchange with MySQL there are two options one of which can be accessed in the connection wizards of SQL Server Integration Services assuming you have installed the programs. The other can be used to set up a ODBC DSN as described further down. The two connection options are:

  • MySQL Connector/ODBC 5.1
  • Connector/Net 5.2 New versions 6.0 & 6.1
In this article we will be using the ODBC connector for MySQL which can be downloaded from the MySQL Site. The connector will be used to create an ODBC DSN. The article describes in detail how the transfer is carried out. Read on ....
this article brought to you by PACKT PUBLISHING.

MySQL Data Transfer using Sql Server Integration Services (SSIS)

Pick up the mechanics of working with SQL Server Integration 2005 under 10 days reading my no brainer book on SQL Server Integration Serivces.

No comments: Protection Status