SQL across multiple data-bases?

Question

question

SQLSlave1956 asked Oct 21, '13

SQL across multiple data-bases?

Is there a way to run a SQL call across multiple data-bases? Will it work if they are different data-bases (e.g. one is SQL server and the other Oracle)? Where can I read up on this?

multi-server

1

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Grant Fritchey ♦♦ commented · Oct 25, 2013 at 10:47 AM

This site runs on votes. Please mark all helpful answers by clicking on the thumbs up. If any one answer lead to a solution, please indicate this by clicking on the check mark next to that answer.

0 ·

Answer 1 · 2013-10-21T13:46:02Z

KenJ answered Oct 21, '13

You can run queries across multiple instances or servers (even non-SQL Server servers) with OpenDatasource, OpenRowset and/or Linked Servers OpenDatasource - [ http://technet.microsoft.com/en-us/library/ms179856.aspx][1] OpenRowset - [ http://technet.microsoft.com/en-us/library/ms190312.aspx][2] Linked Servers - [ http://technet.microsoft.com/en-us/library/ms188279.aspx][3] [1]: http://technet.microsoft.com/en-us/library/ms179856.aspx [2]: http://technet.microsoft.com/en-us/library/ms190312.aspx [3]: http://technet.microsoft.com/en-us/library/ms188279.aspx

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 2 · 2013-10-21T22:31:26Z

Grant Fritchey answered Oct 21, '13

You can also use PowerShell scripts to make the connection to multiple servers. With threads and remoting you can even make those queries simultaneous. I have examples of remoting on my blog, scarydba.com

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

question