Home » Server Options » Replication » Oracle to SQL Server replication
Oracle to SQL Server replication [message #75422] Wed, 03 December 2003 14:47 Go to next message
Anand
Messages: 161
Registered: August 1999
Senior Member
I would like to know, within Oracle9i Streams and Transparent Gateway, which is best solution to use for replication from Oracle9i to SQL Server 2000.
Also, Which one should be used at what situation?
Please clarify.

Regards
Anand
Re: Oracle to SQL Server replication [message #75425 is a reply to message #75422] Tue, 09 December 2003 14:39 Go to previous message
Justin Cave
Messages: 8
Registered: December 2003
Junior Member
Oracle Transparent Gateway allows you to create a database link from Oracle to SQL Server. If you are going to be rolling your own replication system and you don't need a particularly sophisticated solution, Oracle Transparent Gateway would be a good solution. If you need differential rebuilds (i.e. only replicate changes), a more loosely coupled solution, etc. you would want to go with Oracle Streams. You'd have to find some queueing software that would interface with Oracle Advanced Queues (on which Oracle Streams is based) and would also interface with SQL Server.
Previous Topic: How to Centalize the data from remote database
Next Topic: GUI Replication Tool error.. URGENT
Goto Forum:
  


Current Time: Thu Mar 28 06:49:12 CDT 2024