Chapter 13. Implementing and Managing Replication
Replication is a native SQL Server feature that allows a DBA to copy tables, views, indexed views, functions, stored procedures, and so on from one database to another and allows a DBA to control how synchronized the two copies are. In other words, you can replicate changes to both data and schema objects (that is, table, view, or stored procedure changes, and so on). Some replication types allow for bidirectional replication, where changes made on the destination database can be replicated back to the source database.
Replication is best used for the following purposes:
• To move data closer to clients—For example, branch offices might need to access data in a central office, and the network ...
Get Microsoft® SQL Server 2012 Management and Administration, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
