Year: 2010

Helpful References and Links on Setting up Merge Web Synchronization

Sateesh Yele | Microsoft SQL Server Support Below is a list of self-help resources or this scenario. These resources are used by Microsoft SQL Replication Support Engineers during an Advisory Services engagement or while troubleshooting Web Synchronization problems. We hope you too find these helpful.   Web Synchronization for Merge Replication http://msdn.microsoft.com/en-us/library/ms151763.aspx   Topologies for
Read More »

Stored Procedure schema changes are not being replicated when using ”initialize with backup”

SQL Replication allows you to replicate user-defined Stored Procedures code to subscribers similar to replicating tables.  When the sp is modified, the new schema/script is transferred to the subscriber. This ensures all subscribers have the most recent version of the SP. Transactional Replication also allows you to setup a subscriber using a backup of the
Read More »

Change Data Capture Best Practices

Here is a quick list of CDC Best Practices.  Search “CDC” tags for other BLOG posting on designing, supporting and troubleshooting CDC. These recommendation come from various sources including the MSDN CDC White Paper, a recommended read for anyone interesting in tuning CDC performance. Recommendation: Try to avoid scenarios where a row needs to be
Read More »