December 2013
Intermediate to advanced
1872 pages
153h 31m
English
Any SQL Server can play up to three distinct roles in a data replication environment:
Publication server—The publication server (or publisher) contains the database or databases that will be published (the magazine!). This is the source of the data that is to be replicated to other servers. In Figure 40.3, the Customer table (an article in the magazine) in the AdventureWorks2012 database is the data to be published. To publish data, the database that contains the data that will be published must first be enabled for publishing. Full publishing configuration requirements are discussed ...