Database Answers

Home Ask a Question Careers Contact us Data Models First Timers Search Site Map

  SQL Server Replication
 
Replication is distributing changes to data in order to maintain consistent Databases.
Microsoft has initiated some excellent work on Data Design Patterns
There are three Methods of Replication :-
  1. Snapshop - Copies an entire view of data to another computer.
  2. Transaction - INSERT, UPDATE or DELETEs, executed on one computer are replicated to another computer.
  3. Merge - Updates on any computer will be replicated to another computer at a later time.

There are three Components :-
  1. Publisher - source of Data to be replicated.
  2. Distributer - mechanism for distributing replicated data.
  3. Subscriber - targets for replicated Data.

  Here is a series of Useful Links
 

Follow these Links for more useful Information ...
 
Overview A good place to start.
Data Design Patterns Excellent insights and an opportunity to learn from other people's insights.
Data Replication Patterns Download a book and read all about it.
GotDotNet Patterns Community Find out who's doing what.
Teach Yourself SQL Server 2000 A Book with good coverage on Replication.
 

Home Ask a Question Careers Contact us Data Models First Timers Search Site Map