Part 4 in this series on upgrading an Active/Active cluster to SQL Server 2005 details how to push live data from one cluster to another using a conversion DB and replication.  Read more...

SQL Server high availability. Log shipping or replication, clustering or some other solution. It's a challenge and as companies grow more dependent on their databases, it's one that more and more DBAs face everyday. Paul Ibison has taken a look at how log shipping and replication can be compared in the quest for high availability.   Read more...

Recent installments of this series have demonstrated SQL Server 2005 Express Edition's replication characteristics by taking advantage of replication-specific executables and T-SQL code combined with Windows Synchronization Manager and Web Synchronization technologies. This article explores another method of reaching the same goal, which involves Replication Management Objects (RMO).  Read more...

Measure Latencies in Replication implemented using SQL Server 2005  Read more...

One of the four high availability technologies in SQL Server is replication, though this can be very cumbersome to setup and get working. Longtime author Paul Ibison looks at how this has changed from SQL Server 2000 to 2005 and what you should consider before setting this up.  Read more...

While most of the complexity you encounter in synchronization efforts will be unique to your application and infrastructure, synchronization works best when it's designed to be a core feature in each data store.  Read more...

David Poole is a regular author at SQLServerCentral.com, sharing many of his knowledge and experiences with us over the years. This time he examines some of the issues that you might have with replication.  Read more...

Longtime replication expert Andy Warren takes a look at the initial snapshots involved with replication and dives into an explanation of what's involved.  Read more...

Replication can be confusing to many new SQL Server DBAs and some of the optmizations are not well described in Books Online. SQL Server replication expert and trainer Andy Warren brings us a technique for initializing replication without a snapshot.  Read more...

SQL Server 2005 Express Edition's small footprint and free-of-charge use has some negative implications, imposing restrictions on functionality available in the Standard or Enterprise editions. This is especially conspicuous in the case of replication, which we will explore starting with this installment.  Read more...

SQL Server 2000 replication is usually simple and easy to setup and work with. However there are many restrictions to ensure this, one of which is the alteration of a column which is engaged in replication. Author Paul Ibison brings us two options for altering columns.   Read more...

Replication usually involves data, but it can also include stored procedures as well. SQL Server expert trainer Andy Warren brings us a look at how you can ensure that your stored procedures move as well.  Read more...

Continuing with his look at transactional replication, Andy Warren looks at the various delivery options with a detailed analysis of what happens under various configurations.   Read more...

Replication is one of the more useful features in SQL Server and can handle a wide variety of tasks based on his configuration. SQL Server expert Andy Warren takes a look at some of the default transational replication options in this article and what they mean.   Read more...

Robyn Page delves into all the things you need to know, rather than want to know, about SQL Server replication.  Read more...

Setting up replication can be fairly easy, but deviating from the follow-the-wizard approach can be tricky. New author Claudia Rego brings us a primer on setting up transactional replication without requiring an initial snapshot.   Read more...

SQL Server high availability. Log shipping or replication, clustering or some other solution. It's a challenge and as companies grow more dependent on their databases, it's one that more and more DBAs face everyday. Paul Ibison has taken a look at how log shipping and replication can be compared in the quest for high availability.   Read more...

Merge replication is probably not used as often as it could be, mainly because of the potential complexities of this tool. New author Satia Madimchetty brings us a great article that simplifies one part of this SQL Server feature, the conflict resolution issues.   Read more...

Replication is a great tool, but it has a number of restrictions on what you can do with replicated databases. Typically you cannot easily move a replicated database, but our own Andy Warren brings us a technique that can get around this.   Read more...

New author! Mahesh presents a solid overview of the replication architecture of SQL 2000.   Read more...

David Poole is a regular author at SQLServerCentral.com, sharing many of his knowledge and experiences with us over the years. This time he examines some of the issues that you might have with replication.  Read more...

Measure Latencies in Replication implemented using SQL Server 2005  Read more...

One of the four high availability technologies in SQL Server is replication, though this can be very cumbersome to setup and get working. Longtime author Paul Ibison looks at how this has changed from SQL Server 2000 to 2005 and what you should consider before setting this up.  Read more...