Home » Server Options » Replication » Replication from Oracle to SQL Server
Replication from Oracle to SQL Server [message #149467] Thu, 01 December 2005 23:15 Go to next message
ramsat
Messages: 49
Registered: November 2005
Member
How to perform database replication from Oracle to SQL server

Is there any site which could explain things better

Please help in this regard

Thank U
Re: Replication from Oracle to SQL Server [message #161854 is a reply to message #149467] Tue, 07 March 2006 08:15 Go to previous message
rsoma
Messages: 15
Registered: April 2005
Location: Chennai, India
Junior Member
Hi

You need to Establish a linked server connection from SQL Server to Oracle. You need to provide the oracle username/pwd and connect string.

As like other database link access u need to access the oracle table from sqlserver by specifying the Linked Server name.



Soma.
Previous Topic: Replication database
Next Topic: Query on DBMS_SNAPSHOT.DROP_SNAPSHOT
Goto Forum:
  


Current Time: Fri Mar 29 03:54:15 CDT 2024