Sql Query / Table Join between two servers

w.hackl posted 5 years ago in General
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 ?


ansgar posted 5 years ago
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.
jfalch posted 5 years ago
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"..).
jfalch posted 5 years ago
DataController appears to be such an extension of FEDERATED(X).

Please login to leave a reply, or register at first.