Connect TO Sql Server From MySQL

Question

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.

dev.mysql.com/tech-resources/articles/dbixmyserver.html here they talk about something useful: what do you think about it? — Andy
– Andy, Commented Oct 24, 2010 at 15:49

OMG Ponies · Accepted Answer · 2010-10-23 20:27:24Z

2

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.

answered Oct 23, 2010 at 20:27

OMG Ponies

334k85 gold badges536 silver badges508 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Andy Over a year ago

Thanks, is there any proxy software to use instead?

OMG Ponies Over a year ago

@Andy: Sorry, I'm not aware of any or I'd have provided it.

Andy Over a year ago

dev.mysql.com/tech-resources/articles/dbixmyserver.html here they talk about something useful: what do you think about it?

Collectives™ on Stack Overflow

Connect TO Sql Server From MySQL

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related