Yes you can use both Transactional and Merge Replication to move data inserted using the BCP.exe utility of the Bulk Insert command to Subscribers. Considerations For Transactional Replication By default, Transactional Replication will replicate data loaded via BCP or Bulk Insert. For performance, you may want to load data using the bcp Utility –b batch_size
Read More »
Provided by: Suresh B. Kandoth, SR Escalation Engineer, Microsoft SQL Escalation Services These 2 scripts are used by the SQL Server Replication Support team to help analyze the Filter Logic used in Merge Replication. The first lists all defined Subset and Join filters. The first listing shows published table with indexes, the second listing shows
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 »
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 »
Eric Lucht | Microsoft SQL Server Escalation Services Centralized troubleshooting refers to the ability to generate detailed Merge agent log files on both client and Web server (for Web Synchronization), and gather the log files into a central location on the publisher as part of the sync process, no matter where the reconciler is run.
Read More »