SQL Server 7.0
Publication - a collection of articles to subscribe to
Article – a horiz/vertical table slice or stored proc
- Customizable table filter (WHERE clause or stored proc)
- Stored proc may be transaction protected (replicate on commit). Replicates the requests instead of each update.
Snapshot replication makes a copy
Transactional replication maintains the copy by propagating updates from publisher to subscribers
- Post-processes log to store updates in Distribution DB
- Distribution DB may be separate from the publisher DB
- Updates can be pushed to or pulled from subscriber
- Can customize propagated updates using stored procs