Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

What is the effect of running a bulk insert command on a replicated database?

April 26, 2017bulk Command database insert replicated running

0

Posted

What is the effect of running a bulk insert command on a replicated database?

1 Answer

0

Posted

For transactional replication, bulk inserts are tracked and replicated like other inserts. For merge replication, you must ensure that change tracking metadata is updated properly. For more information, see the section “Bulk Inserting Data into Published Tables” in Considerations for Merge Replication.