|
|
|
Re: Who can tell me what the difference between relplication and streams? [message #225999 is a reply to message #221189] |
Thu, 22 March 2007 04:15 |
tahpush
Messages: 961 Registered: August 2006 Location: Stockholm/Sweden
|
Senior Member |
|
|
Replication
Quote: | Replication is the process of copying and maintaining database objects, such as tables,in multiple databases that make up a distributed database system. Changes applied at one site
are captured and stored locally before being forwarded and applied at each of the remote locations.
|
Streams
Quote: | In a nutshell, streams allow information to flow from one database to another without the information having to be an exact copy of the originator.
|
[Updated on: Thu, 22 March 2007 04:16] Report message to a moderator
|
|
|
Re: Who can tell me what the difference between relplication and streams? [message #230411 is a reply to message #225999] |
Wed, 11 April 2007 20:05 |
harshad.gohil
Messages: 157 Registered: April 2007 Location: USA
|
Senior Member |
|
|
Just to add up something.......Streams is not replicating data from one database to other database but it also replicating data from with in the database and outside the database, additionally it can replicate data on bidirectional and depending on rules set you can replicate only for certain DML like only for updates, only for inserts ..etc.
Cheers,
Harsh
|
|
|