Chapter Essentials

SQL Server Replication SQL Server 2008 replication, like the versions of SQL Server before it, is based on a magazine publishing model. You must configure the publisher, distributor, and subscriber to complete a replication configuration.

Replication can be implemented using one of three core replication methods. The first is transactional replication and offers near real-time updates. The second is snapshot replication, and it has lower latency but only consumes network bandwidth periodically. The third is merge replication and is used when updates must be allowed at both the publisher and the subscriber.

Importing and Exporting Data Data can be imported and exported using several methods in SQL Server 2008. The Import/Export ...

Get SQL Server® 2008 Administration: Real World Skills for MCITP Certification and Beyond 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.