Initialization of Merge Replication subscriber fails with primary key violation

Initialization of Merge Replication subscriber fails with primary key violation Troy Moen Microsoft SQL Server Escalation Services We encountered an unusual timing problem while pushing a Snapshot down to a merge subscriber.  We don’t expect many to encounter this problem, after all we’ve only seen it once in 15 years.  We wanted to share this…

0

Replicating data loaded with BCP or Bulk Insert

Replicating data loaded with BCP or Bulk Insert Chris Skorlinski Microsoft SQL Server Escalation Services 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…

0