Sql Query / Table Join between two servers
| User, date | Message |
|---|---|
|
Written by w.hackl
12 months ago Category: General 1 posts since Sat, 02 Jun 12 |
Hi there, is it possible to execute a query between two different servers ? The first is MS SQL the second is MYSQL. The syntax to completely define the first is [Server\Instance].db.dbo.table. By using this syntax i get the error : Wrong syntax near '\' ... Any suggestion or workarounds ? Regards, Wolfgang |
|
Written by ansgar
12 months ago 3950 posts since Fri, 07 Apr 06 |
No, you cannot join between two server instances, only between tables on the same server. I recall Oracle can do that, a colleague of me did that to join some AS400/DB2 database with an Oracle instance on another machine. I can ask him how that worked exactly if you want. |
|
Written by jfalch
12 months ago 222 posts since Sat, 17 Oct 09 |
Between MySQL Servers, this is possible using MySQL´s FEDERATED storage engine, or MariaDB´s FEDERATEDX fork. According to this, it should be possible (but decidedly non-trivial) to modify FEDERATEDX to also access other types of servers (.."write connection classes for other RDBMSs"..). |
|
Written by jfalch
12 months ago 222 posts since Sat, 17 Oct 09 |
DataController appears to be such an extension of FEDERATED(X). |
|
Please login to leave a reply, or register at first. |