INTRODUCTION
MSSQL replication refers to technologies used for copying and distributing data and database objects from a Microsoft SQL Server database to another database
BENEFIT OF SQL SERVER REPLICATION
With SQL Server Replication, businesses can ensure their data is always up-to-date and ready for use. It is a powerful feature that can help businesses ensure data consistency, improve performance, and provide data backup. It is an essential tool for businesses that require multiple databases to be kept in sync.
There are two types of replication which are widely used
*Snapshot Replication
* Transaction Replication
PUBLICATION =>DISTRIBUTOR=>SUBSCRIPTION
FIRST CONFIG DISTRIBUTOR IN SOURCE DATABASE
SELECT SERVER NAME
DEFAULT LOCATION
CREATE DISTRIBUTOR DB NAME
CREATE NEW PUBLICATION
SELECT DB NAME FOR REPLICATION
SELECT TRANSACTIONAL
SELECT TABLE TO REPLICATE
SELECT ANY SPECIFIED COLUMN IN TABLE TO REPLICATE
CREATING SNAPSHOT AGENT
CREATING SUBSCRIPTION
SELECT PUBLICATON
SELECT SERVER TO REPLICATE
Mssql replication wrap Up
we’ve successfully configured Publisher, Local Distributor and a remote Subscriber transactional SQL replication model. You can now insert, delete, or update the data in the Address and AddressType articles to see the data propagation mechanism between the servers.
