p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   SQL Server 2000 (http://p2p.wrox.com/forumdisplay.php?f=20)
-   -   creating SQL 2000 veiws on oracle database (http://p2p.wrox.com/showthread.php?t=44681)

Shwetha June 30th, 2006 05:58 AM

creating SQL 2000 veiws on oracle database
currently my application runs on SQL 2000 server on windows XP system. SQL database derieves its data from oracle database running on unix os. currently i am getting datadumps from oracle and uploading them to sql database. can i create an sql veiw on tables in oracle db under situation mentioned above? if so how? are there any constraints in doing so?

joefawcett June 30th, 2006 06:30 AM

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)

All times are GMT -4. The time now is 05:11 PM.

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.