SearchSQLServer.com

SQL Server database replication tutorial

SQL Server replication, a software package included in Microsoft SQL Server, is used to move data from server to server in a transitionally consistent state from one instance to another.

SQL Server replication can

Replication topology

Replication topology consists of three servers – the subscriber, publisher and distributor. The subscribers are the servers receiving the data. The publisher is the server that holds the initial set of data being made available to the subscribers. The distributor is the server that contains many of the settings. It also holds the data as it is moved from the publisher to the subscribers.

There are three different replication techniques available. They are snapshot replication, merge replication and transactional replication.

Snapshot replication is a single unidirectional push of data. When updated data is fed from the publisher to the subscribers, all of the data is sent each time.

Merge replication is a bidirectional replication that transmits data either in real time, or on a schedule. Merge replication is the only bidirectional replication technique available.

Transactional replication is unidirectional from the publisher to the subscribers. Data can

    Requires Free Membership to View

    By submitting your registration information to SearchSQLServer.com you agree to receive email communications from TechTarget and TechTarget partners. We encourage you to read our Privacy Policy which contains important disclosures about how we collect and use your registration and other information. If you reside outside of the United States, by submitting this registration information you consent to having your personal data transferred to and processed in the United States. Your use of SearchSQLServer.com is governed by our Terms of Use. You may contact us at [email protected].

All Rights Reserved,Copyright 2005 -2012, TechTarget | Read our Privacy Statement