Hi,
Is it possible to use dotConnect for MySQL to create a SQL Server linked server? I am trying to get transaction support which is missing from the MySQL .NET connector.
MS SQL Server linked server to MySQL using dotConnect?
MsSql linked Server to MySql using dotconnect for MySql
Hi there.
I want to create a linked server on ms sql using dotconnect for mysql. I have install dotconnect 5.80.170.0 trial. However, when I select the option to create a new linked server in ms sql server management studio, the dotconnect driver does not show in the provider list. I am not sure what else to do to get it to appear in the list.
Any help is greatly appreciated
Thanks
I want to create a linked server on ms sql using dotconnect for mysql. I have install dotconnect 5.80.170.0 trial. However, when I select the option to create a new linked server in ms sql server management studio, the dotconnect driver does not show in the provider list. I am not sure what else to do to get it to appear in the list.
Any help is greatly appreciated
Thanks
-
- Devart Team
- Posts: 1710
- Joined: Thu 03 Dec 2009 10:48
At the moment, integration with SQL Server Management Studio is not available. We will analyze the possibility of implementing such integration and inform you about the results.
As an alternative, you can use SQL Server Integration Services to copy or move data from your MySQL database to SQL Server:
http://www.devart.com/dotconnect/mysql/ ... _SSIS.html
As an alternative, you can use SQL Server Integration Services to copy or move data from your MySQL database to SQL Server:
http://www.devart.com/dotconnect/mysql/ ... _SSIS.html
-
- Devart Team
- Posts: 1710
- Joined: Thu 03 Dec 2009 10:48