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.  Return to Top of Page |
| 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. Return to Top of Page |
| Failover clustering |
| How does failover clustering work in SQL 2005? Learn how the failover clustering functionality has been extended in SQL Server 2005. Return to Top of Page |
| 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. Return to Top of Page |
| 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. Return to Top of Page |
| 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. Return to Top of Page |
| 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. Return to Top of Page |
| 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. Return to Top of Page |
| 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. Return to Top of Page |
| 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. Return to Top of Page |
| 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. Return to Top of Page |
| 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. Return to Top of Page |
This was first published in August 2007
There are Comments. Add yours.