SQL Replication

Meger Replication

 

1) Allow subscribers to modify information in an offline state and the replicate it back to the publisher ,

2) A subscriber can also replicate information to other subscribers .

3) Provide data filtering. In data filtering, you can filter different updates to different subscribers at different locations.

4) Allow information to be replicated to users who are mobile and are not always connected to the SQL Server.

4) Provide the ability to resolve confilicts that occur during replication .

 

 

Transaction Replication

use this type of replication to progagate incremental changes to from one server to another server immediately, As soon as a change occurs in a database,

1) the data is replicate immediately to its partners . for instance, if there is a row value that changes multiple times, every change will be replicated to its partner,

2) In this type of replication, there are typically fewer subscribers keeping the read-only copy of replicated data.

3) This type of replication does not have the ability to allow subscribers to work offline and then replicate changes when they are back online.

4) This type of replication also does not have the flexibility to filter data during replication.

 

Snapshot Replication

 

1) This type of replication is used when you need to replicate a large volumn of information.

2) This type of replication does not have the ability to allow subscribers to work offline and then replicate changes when they are back online.

3) This type of replication also does not have the flexibility to filter data during replication.

 

 

Peer-to-Peer Replication

 

1) This type of replication is typically used when you need high availablity and scalability

2) This type of replication does not have the ability to allow subscribers to work offline and then replicate changes when they are back online.

3) This type of replication also does not have the flexibility to filter data during replication.