MySQL Forums
Forum List  »  Microsoft SQL Server

Connecting to MySQL using MSSQL2005 Business Intelligence Studio
Posted by: Joel Mansford
Date: October 20, 2005 08:50AM

We are migrating from SQL Server 2000 to SQL Server 2005. We use DTS to shift lots of data around and have been able (to a degree) to shift data to/from MySQL using the ODBC Driver.

Now with SQL Server 2005 you get the replacement for DTS which is pretty neat except there are no ODBC connectors anymore! I tried in vain to install the OLE DB .NET provider for MySql but this doesn't show up as a "Native OLE DB" provider when I try to create a new connection manager.

I guess this post may need to be under a development forum, but I thought I'd try you SQL Server guys first!

I could use flat files and scripts but that is a bit too dirty for me and you don't get any progress indications or anything.

Thanks in advance.

Options: ReplyQuote

Written By
Connecting to MySQL using MSSQL2005 Business Intelligence Studio
October 20, 2005 08:50AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.