Re: Is there an equivalent to "Linked Servers" in MySQL????
Posted by:
clark vera
Date: March 06, 2014 05:07PM
A linked server is available in Microsoft SQL Server and is a VERY handy method of connecting two Microsoft Servers OR a Microsoft Server to a MySQL server.
It enables you to run queries, even joins, on two different tables on two different database on two different physical servers.
Say you have a customer table on server:A1 database:customer table:names
and transaction table on server:B1 database:callrecords table:calls
select * from B1.callrecords.calls where customerid=(select customerid from A1.customer.names where name='Bob Jones';
I have run many call centers with MS Sql Server databases linked to an Asterisk MYSQL database server to get call records and do call Q&A. Clark Vera
http://coresystems.ch/en/about-us/newsroom/category/blog/how-add-linked-server-connection-mysql-mssql/
Subject
Views
Written By
Posted
1587
January 10, 2014 03:04PM
631
January 13, 2014 02:14AM
Re: Is there an equivalent to "Linked Servers" in MySQL????
930
March 06, 2014 05:07PM
625
March 10, 2014 02:50AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.