Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Read from SQL Server to Oracle 1

Status
Not open for further replies.
kvang

kvang

Programmer
Oct 7, 2005
129
US
I have a few tables built and being used in SQL Server. Is there a way for me to query a join with a table in Oracle and SQL Server without having to go through MS Access?
 
Sort by date Sort by votes
Hi
I believe Oracle's heterogeneous services may be what you are looking for.Not, I hasten to add, something about which I know much, however I recall seeing this given as a solution in various posts. You should be able to read up at
 
Upvote 0 Downvote
Make what is called a "linked server" in SQL Server over to the table in Oracle and then treat it like any other SQL Server table in your join from the SQL Server connection.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Sufi Shahzad
  • Locked
  • Question
Fingr printer reader digital personna 4500
Replies
0
Views
547
Sufi Shahzad
Sufi Shahzad
Andrzejek
  • Locked
  • Question
Get part of a string with SQL 1
Replies
2
Views
841
Andrzejek
Andrzejek
KeyserSoze
  • Locked
  • Question
TOAD for Oracle - Icons
Replies
1
Views
284
Andrzejek
Andrzejek
TheLazyPig
  • Locked
  • Question
Oracle Data Validation 1
Replies
4
Views
247
TheLazyPig
TheLazyPig
sqlPower
  • Locked
  • Question
Help with Integer to Char to Datetime stamp
Replies
2
Views
755
SkipVought
S

Part and Inventory Search

Sponsor

Back
Top