SQL Server Replication

Email Alerts

Register now to receive SearchSQLServer.com-related news, tips and more, delivered to your inbox.
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • 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... 

  • Check number of commands to be replicated

    Pinpoint replication performance problems with the view noted in this tip, one of 15 tips in 15 minutes. 

  • Reveal replication commands

    Find out which stored procedure you need to reveal replication commands in this tip, one of 15 tips in 15 minutes. 

  • Achieve bi-directional replication

    If you require bi-directional replication between two servers, you'll find the techniques you need in this tip, one of 15 replication tips in 15 minutes. 

  • Replicate tables without primary keys

    Get steps to convert your table without a primary key in this tip, one of 15 replication tips in 15 minutes. 

  • Replicate to objects with different schemas

    Find out how to use a custom sync object to replicate to objects that have different schemas in this tip, one of 15 tips in 15 minutes. 

  • Snapshot replication

    Excerpted from the McGraw-Hill/Osborne Media book SQL Server 2000 Administration, this tip explains why snapshot replication is the simplest to set up and understand. 

  • Transactional replication

    Excerpted from the McGraw-Hill/Osborne Media book SQL Server 2000 Administration, this tip explains how transactional replication works by sending changes to the subscriber as they happen. 

  • Chapter Download: SQL Server 2000 Administration -- Chapter 10, 'Replication'

    This chapter draws comparisons between SQL Server's publisher, distributor and subscriber components so that you can easily distinguish them and so that you will understand the job of each as it relates to replication. You'll learn the concepts, the ... 

  • replication

    Replication (pronounced rehp-lih-KA-shun) is the process of making a replica (a copy) of something. 

  • Podcast: SQL Server high availability options

    SQL Server high availability options include database mirroring, replication and log shipping. In this podcast series, you'll get the basics and best practices for each. 

  • Podcast: SQL Server replication basics

    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 ... 

About SQL Server Replication

Implementing and maintaining replication within a Microsoft SQL Server database is not a simple task, particularly if you have numerous database servers that need to be involved in various types of replication. such as transactional, merge and snapshot. This topic page features tips and advice on improving SQL Server replication, troubleshooting replication errors and more. Here you'll find resources covering the basics of SQL Server replication, as well as advanced tutorials for more seasoned database administrators. Browse the links below for help recognizing the benefits of SQL Server replication in your environment.