dear all, 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 Thanks a lot, Andy
+1
A:
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.
OMG Ponies
2010-10-23 20:27:24
Thanks, is there any proxy software to use instead?
Andy
2010-10-23 20:34:46
@Andy: Sorry, I'm not aware of any or I'd have provided it.
OMG Ponies
2010-10-23 20:35:42
http://dev.mysql.com/tech-resources/articles/dbixmyserver.html here they talk about something useful: what do you think about it?
Andy
2010-10-24 15:37:11