SQL statement joining Oracle and MS SQL Server

sql sql-server oracle join remote-server
bmw0128 picture bmw0128 · Oct 22, 2010 · Viewed 10.6k times · Source

I never seen this, but is it possible to have one SQL call join data from Oracle and SQl Server?

Answer

OMG Ponies picture OMG Ponies · Oct 22, 2010

Yes, Oracle and SQL Server both have functionality that allows to connect to other databases, including different vendors. In Oracle terminology, it's a database link instance while on SQL Server it's called a Linked Server instance.

The syntax to reference the instance is different between Oracle and SQL Server though. IE:

Oracle:

SELECT t.*
  FROM table_name@database_link_instance t

SQL Server:

SELECT t.*
  FROM linked_server_instance_name.database_name.schema_name.table_name t

does MySQL support the linked server concept?

No, the closest MySQL has is the FEDERATED engine, which is only for connecting to remote MySQL instances.

PostgreSQL?

PostgreSQL has dblink. Last time I looked at dblink (pre-v9 release), it only could connect to other PostgreSQL instances.

Related questions

How do I list all the columns in a table?

For the various popular database systems, how do you list all the columns in a table?

Read More
Is there a combination of "LIKE" and "IN" in SQL?

In SQL I (sadly) often have to use "LIKE" conditions due to databases that violate nearly every rule of normalization. I can't change that right now. But that's irrelevant to the question. Further, I often use conditions like WHERE something …

Read More
Can a foreign key be NULL and/or duplicate?

Please clarify two things for me: Can a Foreign key be NULL? Can a Foreign key be duplicate? As fair as I know, NULL shouldn't be used in foreign keys, but in some application of mine I'm able to input …

Read More