MySQL 4.1 Migration to SQL Server 2005 using SSIS


How do I migrate from MySQL 4.1 to SQL Server 2005 using SSIS. I am not able to find a suitable provider which can be used with MySQL 4.1.
LVL 7
assystAsked:
Who is Participating?
 
YveauConnect With a Mentor Commented:
Try using the ODBC drivers for MySQL:
http://dev.mysql.com/downloads/connector/odbc/3.51.html

When you manage to setup a DSN using that ODBC driver, than from SSIS, make a connection to a regular ODBC datasource ... and you'll be in business.

Hope this helps ...
0
 
Marcel HopmanCommented:
You can use a DataReader Source and connect a ODBC source to it
0
 
assystAuthor Commented:

mahopman,
DataReader source is the adapter used to connect to an ADO.Net source, so can that be used for MySQL
0
 
Marcel HopmanConnect With a Mentor Commented:
No you can also connect a ODBC data connection to a DataReader Source
0
 
assystAuthor Commented:
Thanks to both of you. I managed to get it working.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.