Tag: BCP

Merge agent failing with “Cannot insert duplicates rows into table “tablename”. Violation of PRIMARY KEY constraint” during initialization.

Sateesh Yele Microsoft SQL Server Support Last week, I worked on replication case where the merge agent was failing with the above error message. Here is the merge agent verbose log with the error message. Message: Batch send failed 2011-04-20 13:53:00.546 [39%] [346 sec remaining] Bulk copied data into table ‘MSmerge_tombstone’ (0 rows) 2011-04-20 13:53:00.843
Read More »

Replicating data loaded with BCP or Bulk Insert

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 »