SQL Server 2K5 to MySQL 5 - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SSIS and Import/Export (2005)

SQL Server 2K5 to MySQL 5

Author

Topic

Architect
Starting Member

8 Posts

Posted - 2008-02-28 : 17:14:48

I need to pull data out of SQL Server 2005 and load it into a MySql 5 database, and can't find a way to do this efficiently in SSIS since there's no ODBC destination, and I couldn't find an Oledb driver for MySQL. Any thoughts on the best way to accomplish this, aside from exporting to text, and then loading it into MySql via the mysql client or mysql importer?

-A

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-02-28 : 18:18:00

If you install whatever driver mysql 5 uses onto the SQL Server, then you'll have that driver available in SSIS.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2008-02-28 : 20:51:25

maybe you should ask this question over at MySQL forumn and also search mysql site on migrating.

http://dev.mysql.com/tech-resources/articles/migrating-from-microsoft.html

KH
[spoiler]Time is always against us[/spoiler]

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-03-01 : 22:34:10

You can download MySql odbc driver from MySql site.

Architect
Starting Member

8 Posts

Posted - 2008-03-03 : 23:29:56

The ODBC driver doesn't solve the issue since SSIS only supports OLEDB destinations.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-03-03 : 23:36:47

quote:
Originally posted by Architect

The ODBC driver doesn't solve the issue since SSIS only supports OLEDB destinations.

Since when?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-03-03 : 23:38:47

Microsoft has ole db provider for odbc driver by the way.

opc.three
Starting Member

5 Posts

Posted - 2012-06-29 : 15:57:45

quote:
Originally posted by tkizer

quote:
Originally posted by Architect

The ODBC driver doesn't solve the issue since SSIS only supports OLEDB destinations.

Since when?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

I know I am grave-digging on this thread but this is a top result on Google when looking for info on loading data into MySQL using SSIS 2005 so I wanted to update the thread.

Architect is correct. In SSIS 2005, which the OP is using, we do not have a true "ODBC Destination" component.

In SSIS 2008 we can load data using ODBC, however only via the "ADO NET Destination".

It was not until SSIS 2012 was delivered earlier this year that we gained native access to ODBC as a destination: http://msdn.microsoft.com/en-us/library/hh758691%28v.11.0%29.aspx

Make everything as simple as possible, but not simpler. -- Albert Einstein

opc.three
Starting Member

5 Posts

Posted - 2012-06-29 : 16:01:18

quote:
Originally posted by rmiao

Microsoft has ole db provider for odbc driver by the way.

MSDASQL was deprecated before SQL Server 2005 was released and never worked with SSIS 2005.

Make everything as simple as possible, but not simpler. -- Albert Einstein

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources