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

[FancyPrairie]

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]

See "Linked Servers".

http://www.google.com/search?source...ls=GGLG,GGLG:2006-26,GGLG:en&q=linked+servers

 

[FancyPrairie]

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]

Happy to help!

 

[FancyPrairie]

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?

 

[Turkbear]

Hi,
Only Oracle tools ( and Tools designed for Oracle, like TOAD, etc) can do any design-level operations..(DDL as opposed to DML).





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[dvannoy]

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...

 

[FancyPrairie]

I found that I can drag the table and/or view onto the query grid. I can then design the query.