Take the 2-minute tour ×
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. It's 100% free, no registration required.

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
add comment

1 Answer 1

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
add comment

Your Answer

 
discard

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.