CODEWITHSUNDEEP
mysqllinked-server
Andy
Andy

Reputation: 41

Connect TO Sql Server From MySQL

How can I connect to a SQL Server Database from a MySQL Server? I need to use the MySQL as a proxy DB (querying all the SQL servers and MySQL connected to it).

I need a functionality sort of "linked server" one on SQL server.

Upvotes: 4

Views: 5401

Answers (1)

OMG Ponies
OMG Ponies

Reputation: 332701

You can't - the closest MySQL has is the FEDERATED engine, but it only supports connecting to other MySQL instances, not any other database vendor.

Only SQL Server's Linked Server and Oracle's Database Link technology support connecting to other database vendors (that I'm aware of), so you'd have to use SQL Server as the proxy to MySQL -- not the other way around.

Upvotes: 2

Related Questions