Is a Transactional Replication Snapshot processed as a 'bulk insert'

337 views Asked by At

I have a Merge replication that sources on a subscription from a Transactional Replication. I know that the triggers regarding the Merge replication are not fired by 'bulk inserts':

Microsoft: When data is loaded into tables using the bcp Utility or the BULK INSERT command, by default, the merge replication triggers that maintain tracking data in the MSmerge_contents system table are not fired.

For establishing the transactional replication a snapshot is needed. Question: is the snapshot a bulk insert; will it not fire the merge triggers?

1

There are 1 answers

0
user3248190 On BEST ANSWER

Snapshot can only be done when the merge publication is dropped. Otherwise I get an error saying that the tables are locked by replication.

Bottom line is that it is not possible to do a snapshot on a replication where the subscription database is a source for an other replication.

Besides this, according to Microsoft: "The snapshot is generated as a set of bulk copy program (BCP) files."

So to my knowledge the snapshot is processed as a bulk insert.

Please correct me if I am wrong!