Merge Replication: Import Data

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Javed Iqbal - 28 Dec 2005 10:41 GMT

Hi,

I have MERGE setup between SERVER A (Publisher)---- SERVER B (Subscriber).

in a table on SERVER A i am importing data from an excel sheet say 100
records. But these records are not reflecting on SERVER B even after merge
agent runs several time.

What would be be possible cause?

Thanks in advance.

Regards
Javed

Reply to this Message

Hilary Cotter - 29 Dec 2005 03:06 GMT

When you use DTS by default triggers are not fired; in the options tab of
Transform Data Task Properties uncheck the Use Fast Load option to have your
triggers fired. You need to issue a sp_addtabletocontents 'tableName' to
replicate its contents.

Signature

Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

> Hi,
>
[quoted text clipped - 10 lines]
> Regards
> Javed

Reply to this Message