Geek Answers Handbook

How to create a linked MySQL server

Is it possible to create / configure MySQL for features such as SQL Server Linked Server?

If yes, please tell me how? I am using MySQL 5.5.

+6
mysql linked-server
source share
3 answers

The MySQL FEDERATED engine provides functionality similar to SQL Server Linked Server (and Oracle dblink), but does not support connections to non-MySQL providers. It's unclear if you need functionality to connect to non-MySQL providers.

You might want to learn MySQL Proxy . This is not consistent with the architecture of Linked Servers / dblink, but you can probably solve a similar set of problems that you would use Linked Servers / dblink to solve.

+10
source share

I am a developer of MySQL Data Controller. Unfortunately, since we had no requests, we stopped developing. The plugin was 100% functional with MySQL connection to Oracle, MSSQL or MySQL.

Based on some queries, we added a blog back and a video about this:

http://www.acentera.com/mysql-datacontroller/

Regards, Francis L.

+3
source share

The MySQL data controller is a continuation of the join mechanism, which allows you to connect to various types of databases, such as Microsoft SQL Server or Oracle. I'm still not sure how it is developing.

See: http://en.wikipedia.org/wiki/MySQL_DataController

or: https://launchpad.net/datacontroller

+1
source share

More articles:


All Articles