?
Solved

Replication Push or Pull to MS SQL

Posted on 2005-04-20
1
Medium Priority
?
318 Views
Last Modified: 2010-03-19
I was wondering if someone could tell me if it is possible to create Replication Push or Pull from Oracle to MS SQL?
With the functionality being setup in MS SQL...

0
Comment
Question by:Tacobell777
1 Comment
 
LVL 21

Accepted Solution

by:
Kevin3NF earned 1000 total points
ID: 13833401
Yes.

From Books Online (search for "replication oracle":

Oracle Subscribers
Microsoft® SQL Server™ 2000 includes an ODBC driver and OLE DB provider that support Oracle subscriptions to SQL Server publications on Intel computers. SQL Server 2000 Setup installs the driver automatically.

Note  To replicate to Oracle ODBC and OLE DB Subscribers, you must also obtain the appropriate Oracle SQL*Net driver from Oracle or from your software vendor. You must then install the driver on the Publisher and the Distributor.


You will want to read the rest of the article for some caveats and restrictions....
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I have a large data set and a SSIS package. How can I load this file in multi threading?
This shares a stored procedure to retrieve permissions for a given user on the current database or across all databases on a server.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Suggested Courses

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question