October 24, 2006 at 12:34 am
Hi all, Can u give me exact difference b/w snapshot,transactional,merge replication.
October 24, 2006 at 5:20 pm
There are two forms of "snapshot" and since you are posting in the "notification" section, vs. in the 7/2000 or 2005 DB sections (both of which have "replication" forums), it's a little hard to know what you are looking for.
The new 2005 feature of snapshot is an empty set of DB files that are taken at a point in time, and ONLY the changes (additions, deletions, etc) are stored in the new DB (files). For the snapshot to work you must continue to have the DB on which it is based.
The "old" snapshot is the initial "picture" of the database... if only used in replication, it is just a static copy of an existing DB. Changes are not propagated to or from this DB without manual intervention.
Transactional replication is based on a snapshot; but there is also a log reader on the original DB that uses the distribution DB to make changes from the source to the target. Changes on the target (the snapshot) are not made back to the source.
Merge replication allows changes in both directions, and/or multiple directions. In the ideal world you can update anything anywhere... in reality, it is just data distribution, and there are "rule" that have to be followed with distributed data. You really don't update anything anywhere without a lot of work resolving collisions.
Thank-you,
David Russell
Any Cloud, Any Database, Oracle since 1982
October 26, 2006 at 4:36 am
Read also here
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply