O'Reilly logo

Microsoft® SQL Server™ 2005: Applied Techniques Step by Step by Solid Quality Learning

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Using Replication to Transfer Your Data

Replication is a tried and true method for moving data between databases and servers. SQL Server 2005 supports three significant variations of replication. These replication methods have been part of the SQL Server platform for quite a while:

  • Snapshot Replication

  • Transactional Replication

  • Merge Replication

SQL Server 2005 also supports a new concept called Peer-to-Peer Replication. This concept is actually a series of servers that are configured to use Transactional Replication to move data between servers.

Of the methods available for transferring databases, replication tends to be the least easily understood as well as the most difficult to design and maintain. Both the source and the target, referred ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required