Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 298
  • Last Modified:

Can mysql refer ms-sql database by using like linked server

i understand that i can create linked server in MS-SQL for my sql.
But, In mysql, can i query ms sql table

is there linked server function in MYSQL..?
i appreciate any comments

Thanks

0
ndoorsinteractive
Asked:
ndoorsinteractive
1 Solution
 
Kevin CrossChief Technology OfficerCommented:
MySQL does not really have a concept of a Linked Server (well http://dev.mysql.com/doc/refman/5.5/en/federated-storage-engine.html, but that only talks to other MySQL servers at the moment); therefore, the answer is NO you cannot go the opposite way. Sorry.
0
 
HainKurtSr. System AnalystCommented:
not supported yet... maybe 6.x version will allow :)
what is your requirement? maybe you can solve it with some tasks/jobs on SQL server with db link to mySQL db...
or your app can connect to both db...
0
 
ndoorsinteractiveAuthor Commented:
didn;t find alternative solution yet
0

Featured Post

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now