Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
workindan
Starting Member
21 Posts |
 Posted - 2011-05-05 : 10:06:06
|
| I don't know if this is the right forum for this question...Is there any software that can cross query multiple databases simultaneously (as in, within the same query) across different database types? They would be: Oracle, Sybase, DB2 and SQLServerI know there are tools that query each one independently and can 'compare' them, but is there a way write one sql command that can reach all four at the same time? |
|
|
lionofdezert
Aged Yak Warrior
885 Posts |
Posted - 2011-05-05 : 10:24:19
|
| From sql server you can access any OLEDB by using OPENROWSET option, like to get data from table T1 of oracle, using tsql select * from openrowset('OraOLEDB.Oracle', ' i2';'abc';'S!123', 'select * from T1')--------------------------http://connectsql.blogspot.com/ |
 |
|
|
Jahanzaib
Posting Yak Master
115 Posts |
Posted - 2011-05-06 : 07:44:17
|
| you can use Linked Server in SQL SERVER and Database Link in Oracle to query to another server of the same or different databasesRegards,Syed Jahanzaib Bin HassanMCTS,MCITP,OCA,OCP,OCE,SCJP,IBMCDBAMy Blogwww.aureus-salah.com |
|
|
|
|
|
|
|
|
Cross Database Querying