Configuring replication on SQL Server
In this part of the chapter, we will focus on SQL Server replication in detail and we'll see how to configure replication for a database between different servers. Like with many other features, the configuration can be done with SQL Server Management Studio (GUI) or with T-SQL code, which sometimes provides greater flexibility. Be aware that replication is one of the features that you can configure immediately during installation to be available on your system. In case you haven't installed the feature, you can always add replication to the existing SQL Server instance:

Replication topology includes several roles for servers and offers various scenarios. The primary roles we will work with are as follows:
Subscriber
Publisher
Distributor
Let's read a little about each of the roles:
Publisher
is the primary server in the replication topology, which hosts the source data. On thePublisher
server, we need to create a replicationPublication
, which is a unit...