Replication techniques in SQL Server

The following list will educate you on the replication process in SQL Server and also guide you on how to enhance your techniques when replicating your database(s). If you have database servers that must be involved in various types of replication, a simple task can quickly become complex. Before you make the decision to replicate, take a look at the resources we've gathered to guide you on your journey.

The following list will educate you on the replication process in SQL Server and also guide you on how to enhance your techniques when replicating your database(s). If you have database servers that must be involved in various types of replication, a simple task can quickly become complex. Before you make the decision to replicate, take a look at the resources we've gathered to guide you on your journey.

Merge replication

How merge replication works
When you meet up with an old friend, you immediately try to recall when you last met so you know how much you have to catch up on. Merge replication works in a similar way. Get up to speed on merge replication in this tip, the first in a three-part series by contributor and Microsoft SQL Server MVP Hilary Cotter.

Managing identity columns

Managing identity columns with replication in SQL Server
Managing identity columns with replicated tables in your SQL Server 2005 database requires some TLC. In these scenarios, see how to replicate tables with identity columns and also get options to manage identity seeds for replicated tables. You'll see that you don't have to ditch identity columns to use replication, just handle them with care.

Failover clustering

How does failover clustering work in SQL 2005?
Learn how the failover clustering functionality has been extended in SQL Server 2005.

10 tricks to merge

Ten merge replication tips and tricks
From schema and parameter changes to wrapping and limiting merge agents, SQL Server MVP Hilary Cotter offers various tricks to help you get the best performance from your merge replication efforts.

Take 3: Merging methods

Understanding replication methods: Snapshot, transactional and merge In this book excerpt, you will learn the process, the advantages and disadvantages, and tips on when to use three different replication methods: snapshot, transactional and merge.

Automatic switchover

Setting up automatic switchover between SQL Server instances
Since SQL Server 2000, you have been able to create a standby server using replication, log shipping and backup and restore -- but now Microsoft has introduced Database Mirroring, a built-in tool that enables automated failover.

Database mirroring

SQL Server 2005 Database Mirroring primer
Since SQL Server 2000, you have been able to create a standby server using replication, log shipping and backup and restore -- but now Microsoft has introduced Database Mirroring, a built-in tool that enables automated failover.

Clustering vs. replication

Hardware clustering vs. replication: A case study
A real-life example showing the superiority of software replication over hardware clustering to maximize data availability.

Log shipping

Log shipping a replicated database
Log shipping allows you to automatically copy and restore transaction logs to another database on a standby server. Find out how and when to use it for a replicated database.

Optimize performance

Optimize merge replication performance
Improve merge replication performance with methods explained in this tip and foster a highly scalable SQL Server environment. SQL Server expert and Microsoft MVP Hilary Cotter explains the tuning process and helps you determine if merge replication is right for you.

Enhancements and discontinued features

SQL Server 2005 replication enhancements and discontinued features
SQL Server 2005 offers significant replication enhancements, from secure passwords to full data type support. Edgewood Solutions' Jeremy Kadlec reviews the new enhancements as well as discontinued replication features.

Replication podcast

SQL Server replication podcast
In this podcast, you'll grasp the functionality of replication and what it can do for your SQL Server environment. SQL Server database administrator Eric Johnson starts by explaining the three replication types: snapshot, transactional and merge. He then takes you through setting up replication for high availability and outlines how to failover a replication solution.

This was first published in August 2007

Dig deeper on SQL Server Replication

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close