distal-attribute
distal-attribute
distal-attribute
distal-attribute

Sql Query / Table Join between two servers

User, date Message
Written by w.hackl
2 years 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
2 years ago
5009 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 jfalchMoney, Euro
2 years ago
398 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 jfalchMoney, Euro
2 years ago
398 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.