Replication techniques in SQL Server

Merge_replication 10 tricks to merge Database mirroring Managing identity columns Take 3: Merging methods Clustering vs. replication Failover clustering Automatic switchover Log shipping Optimize performance Enhancements and discontinued features Replication podcast

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

Digg This!     StumbleUpon     Del.icio.us

RELATED CONTENT SQL Server replication SQL Server replication methods: Snapshot, merge or transactional Licensing a standby server for SQL Server replication Upgrade live applications to SQL Server 2005 for high availability Tool to synchronize two SQL Server databases Synchronize databases on two separate active servers SQL Server Blog Watch Simplify SQL Server replication Podcast: SQL Server high availability options Managing identity columns with replication in SQL Server Podcast: SQL Server replication basics SQL Server backup and recovery Solve SQL Server errors and more from the DBA trenches -- part 2 Licensing a standby server for SQL Server replication Can I encrypt and restore a database backup in SQL Server 2005? SQL Server errors, failures and other problems fixed from the trenches Get SQL Server log shipping functionality without Enterprise Edition SQL Server 2008 backup compression pros and cons SQL Server backups using SAN database snapshots Tips for scheduling and testing SQL Server backups Code to restore SQL Server databases in VB.NET Tricking SQL Server into making full database backups SQL Server backup and recovery Research Strategy and planning Tutorial: Performance tuning SQL Server via queries, indexes and more SQL Server virtualization pros and cons: Weigh the performance impact SQL Server database design disasters: How it all starts Can you shrink your SQL Server database to death? Tuning SQL Server performance via memory and CPU processing Tuning SQL Server performance via disk arrays and disk partitioning Virtual database storage for SQL Server: Friend or foe? SQL Server high availability when upgrading to SQL Server 2005 Secure SQL Server from SQL injection attacks How insiders hack SQL databases with free tools and a little luck

RELATED GLOSSARY TERMS Terms from Whatis.com − the technology online dictionary replication  (SearchSQLServer.com)

RELATED RESOURCES 2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems Search Bitpipe.com for the latest white papers and business webcasts Whatis.com, the online computer dictionary