Walkthrough Setting up SQL 2008 Peer-2-Peer Replication

Sudharshan Prahallada, Microsoft SQL Replication Support team walks through setting up Peer-2-Peer Transactional Replication on SQL 2008.  You can view this video from the BLOG or double-click to open in YouTube.  He did a great job showing the Peer-2-Peer Wizard and explaining how it all comes together in a 5 minute video. For demonstration purposes
Read More »

Programming Replication Management Objects RMO

Eric Burgess | Microsoft SQL Server Escalation Services You can programmatically setup and configure Merge Replication using Replication Management Objects (RMO). How to: Create a Pull Subscription (RMO Programming) http://msdn.microsoft.com/en-us/library/ms147314.aspx Replication in SQL Server Express http://msdn.microsoft.com/en-us/library/ms165700(SQL.90).aspx SQL Server Express does not include the SQL Server Agent, which is typically used to run replication agents. If
Read More »

Using Windows Synchronization Manager on x64 to Synchronize Replication

Windows Synchronization Manager on x64 SQL 2005 BOL topics describe how to launch the Windows Synchronization Manager to synchronize a subscriber. How to: Synchronize a Subscription Using Windows Synchronization Manager (Windows Synchronization Manager) http://msdn.microsoft.com/en-us/library/ms151863.aspx On x64 system, the BOL steps will start the x64 Win Sync Manager not the 32bit version.  The x64 bit will
Read More »

Walkthrough setting up SQL Replication Distributor using TSQL commands

The scripts below and the video capture walkthrough setting up a Microsoft SQL Server Replication Distributor using SQL commands. As discussed in previous posting, the Distributor is a key role in Replication.  It serves as a “cache” holding transactions for Transactional Replication and history tracking for all types of Replication.  I’ve highlighted some of the
Read More »