Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

When I import some data from excel file to a table that is part of a merge replication, the data is imported successfully to the table, but those new records are not synced to subscribers that belong to the merge replication topology!

Is this by default?

Am I missing some configuration ?

share|improve this question

It turns out that the Import wizard ( because it is considered like a Bulk Insert or BCP ) is disabling replication triggers on the tables they are loading data to, which prevents Merge Replication from detecting new records.

This article: Bulk loading data into a merge replicated table explains this with more details.

One workaround is to use the procedure: sp_addtablecontents after importing data to let the merge replication detect the new rows like the following:

Exec sp_addtabletocontents @table_name = 'Customers'
share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.