View Single Post
  #2 (permalink)  
Old June 30th, 2006, 06:30 AM
joefawcett's Avatar
joefawcett joefawcett is offline
Wrox Author
Points: 9,763, Level: 42
Points: 9,763, Level: 42 Points: 9,763, Level: 42 Points: 9,763, Level: 42
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Exeter, , United Kingdom.
Posts: 3,074
Thanks: 1
Thanked 38 Times in 37 Posts
Default

Providing you have access permissions you can set up a LINKED SERVER in SQL Server, either using the Enterprise Manager GUI or by scripting. You can then access the data in Oracle and perform queries whereby you insert into a SQL table data from an oracle one. Alternatively, for a more transient connection, you can use OPENQUERY or OPENROWSET and pass a connection string in. Search for the capitalised terms in BOL.

--

Joe (Microsoft MVP - XML)
Reply With Quote