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 ?


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'
| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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