question

Sai Prabhu avatar image
Sai Prabhu asked

Replication-Subscriber Data Overwriting

Hi everyone, I am having a problem in Replication. Both Publisher and Subscriber are SQL SERVER 2008 R2 Enterprise Editiions. We have to configure replication between these two servers. The problem is, the replication should be Unidirectional, i.e,.. Subscriber data should not be replicated to publisher. Also, the data at the subscriber should not be overwritten. Sometimes data at the subscriber gets updated. So, replication should be configured in such a way that, the publisher data should be updated at the subscriber without overwriting the existing subscriber data. Is there any option in Replication to make this possible. What type of replication i shud use. Thanks in advance. Regards, Sai
replication
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
WilliamD avatar image
WilliamD answered
If you use transactional replication to send data from the publisher to the subscriber you will still be able to update the data at the subscriber end. Any changes made will not be sent back to the publisher, you just have to be careful of any foreign key relationships etc. that could be affected by this type of change. Also be aware of what impact this would have on the data integrity/quality. If there is a clear case for wanting a modified copy of your data, then you can do this. Without any further information, it seems a strange thing to want to do.
2 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Sai Prabhu avatar image Sai Prabhu commented ·
Thanks for your answer. I am planning Transactional Replication with updatable subscriber. If triggers in Subscriber database tables is disabled,then no updated data will be replicated to publisher right?
0 Likes 0 ·
WilliamD avatar image WilliamD commented ·
That is right, but why do it that way if you don't want the subscriber to update the publisher?? Just use standard transactional replication and you don't need to worry about the update triggers.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.