Configuring replication on SQL Server

In this section, we will focus on SQL Server replication in detail and we'll learn 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 (SSMS) or with Transaction-SQL (T-SQL) code, which sometimes provides greater flexibility. Be aware that replication is one of the features that you can configure immediately during installation so that it's available on your system. If you haven't installed the feature, you can always add replication to your existing SQL Server instance, as follows:

Fig. 5.6 – SQL Server Replication setup

The replication topology includes several roles for servers and offers various scenarios. The primary roles we will be working with are as follows:

• The Publisher: The Publisher is the primary server in the replication topology and hosts the source...