| Oracle to SQL Server replication [message #75422] |
Wed, 03 December 2003 14:47  |
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  |
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
