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...
