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!

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

How do I join an Oracle table to a Microsoft SQL table? 1

Status
Not open for further replies.

FancyPrairie

Programmer
Oct 16, 2001
2,917
US
I have an Oracle table that represents our Employee database. I have a Microsoft SQL table that also represents our Employees. I would like to join the 2 tables based on the Employee ID.

How do/Can I do this?
 
BoulderBum,

I found what I was looking for via your link. I got it working on the 19th but higher priority things came up and am just getting back to it.

As I started to work on it today I realized that I forgot to thank you. So, thanks alot. Your suggestion made maintaining my databases much easier.
 
BoulderBum,

I have a question about linked servers:

In the SQL Enterprise Manager, I can see the names of the tables and views of the Oracle database I linked to. However, I can not view the design of the tables or views nor open them.

Normally I simply right click on the table or view and select from the popup menu the option I want (design or open). The only options available when I right click on the Oracle tables/views is "Copy" and "Help".

Is this by design or am I missing something?
 
Hi,
Only Oracle tools ( and Tools designed for Oracle, like TOAD, etc) can do any design-level operations..(DDL as opposed to DML).



[profile]

To Paraphrase:"The Help you get is proportional to the Help you give.."
 
The purpose of using a linked server is just that "to Link it" that's it. I typically select my records from the linked servers views rather then the tables. you can also look into replication, maybe use a publisher and a subscriber...

 
I found that I can drag the table and/or view onto the query grid. I can then design the query.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top