How to create linked server MySQL

mysql linked-server
Tioma picture Tioma · Mar 20, 2011 · Viewed 52.3k times · Source

Is it possible create/configure MySQL for functionality like SQL Server's Linked Server?

If yes, would you please tell me how? I'm using MySQL 5.5.

Answer

OMG Ponies picture OMG Ponies · Mar 20, 2011

MySQL's FEDERATED engine provides functionality similar to SQL Server's Linked Server (and Oracle's dblink) functionality, but doesn't support connecting to vendors other than MySQL. It's not clear from the question if you need the functionality to connect to vendors other than MySQL.

You might want to look into MySQL Proxy. This doesn't match 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.

Related questions

How does OPENQUERY differ for SELECT and INSERT?

I'm aware that the following query will pull down the result set from a linked server: SELECT * FROM openquery(DEVMYSQL, 'SELECT event_id, people_id, role_id, rank, last_updated FROM event_cast') However, is this the same case when …

Read More
SELECT * FROM Linked MySQL server

I have a SQL Server 2012.(120.120.55.15) Today I linked MySQL server(120.120.55.30) to my SQLServer and gave it a name "MYSQL". In Object Explorer everything seems fine. I can see MySQL server's database "exampleDataBase" and tables in it. But when I try …

Read More
SELECT * FROM MySQL Linked Server using SQL Server without OpenQuery

I am trying to query a MySQL linked server using SQL Server. The below query runs just fine. SELECT * FROM OPENQUERY([Linked_Server], 'SELECT * FROM Table_Name') Is it possible to run the same query without using the OpenQuery call?

Read More