Are ALL updates passed to the subscriber.

Question

Post reply

Are ALL updates passed to the subscriber.

kangarolf

Hall of Fame

Points: 3432
More actions
November 12, 2002 at 6:39 am

#80266

I am using transactional replication on a couple of tables. The data locally is imported to a temp table, new rows are inserted, old ones are deleted and existing ones are updated on the replicated table.

At the minute I am doing a simple update via a primary key comparision on the columns of each row that contain variable data (stock levels, pricing). This data is imported locally every 5 minutes.

My question is this;

If the update on a row results in no change to the data (ie the imported temp table still has the same data as the 5 minute old local table) will the update still be interpreted by the log reader as a transaction that needs to be sent to the subscriber..?

I am attempting to reduce the traffic between the two and this seemed like a good place to start!

Thanks

Rolf

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Mkumari Hall of Fame Points: 3498 More actions · Answer 1

Mkumari

Hall of Fame

Points: 3498

November 12, 2002 at 8:04 am

#441117

I think it will see those records as updates, since the replication triggers fire when the data gets over written from the temp table to the replicated table even though there is no change in the date.