SQL Remote replication design and set up


Creating SQL Remote systems
Publications and articles
User permissions
Subscriptions
Understanding transaction log-based replication
Replication conflicts and errors
Update conflicts
Row not found errors
Referential integrity errors
Duplicate primary key errors
Partitioning rows among remote databases
Using disjoint data partitions
Using overlap partitions
Assigning unique identification numbers to each database