You can use SQL Server Replication technologies to move data between local on premises SQL Server to SQL Server running in Windows Azure Virtual Machines or between Windows Azure Virtual Machines. Similar to move data between non-trusted corporate domains, keys are 1) use SQL Server Authentication and 2) configure a client alias for the server
Read More »
1) MaxBCPThreads (contributed by Sanjaya Padhi, Microsoft SQL Server Support) I found we can add in the below point to increase the perf of the snapshot application by the distribution agent by use of MaxBCPThreads parameter as mentioned in the article below. Please note this does not apply when Snapshot created using default “concurrent” option.
Read More »
For SQL 2005 and SQL 2008 the sp_removedbreplication stored procedure works great for removing the SQL Replication bits from a database. SQL 2000 has an older version of this SP which doesn’t always cleanup the database. You can use the following steps in SQL 2000 to remove the leftover Replication bits. Problem Description – Manually
Read More »
Content provided by: Steve Dybing, Microsoft SQL Server Support Background on Merge Conflicts ———————————————- When a Publisher and a Subscriber are connected and synchronization occurs, the Merge Agent detects if there are any conflicts. If conflicts are detected, the Merge Agent uses a conflict resolver (which is specified when an article is added to a
Read More »
I was recently asked for recommendations for Merge Replication capacity planning project. While I spend most of my time tuning and troubleshooting Replication environments, I decided to post some thoughts on about stress testing and capacity planning. I hope this posting helps as you are designing your Merge Replication environment. Background Reading Merge Replication Performance
Read More »