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

Report message to a moderator

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.

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Aug 05 09:06:50 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.