September 4, 2008 at 2:53 pm
Hi,
I set up a transactional replication that replicates table A from server 1 to server 2.
This table A on server 2 (subscribed article) is sometimes updated not by replication job but
by users, does it affect Replication job?
Thank you.
Hai
September 4, 2008 at 3:53 pm
Do you want the data that is updated on the server2 table to replicate back to the server1 table? If so, then you could create the transactional publication to allow for updateable subscriptions.
If the question is will it just affect transactional replication, I don't believe so however, if you are going to get server2 in sync with server1 again you will lose your updates and will most likey have to do a full snapshot of the data again.
Someone correct me if I am wrong on this. Thanks.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
September 4, 2008 at 4:01 pm
Thank you David,
I do not want table A on server 2 to be replicated back to server 1.
If I did, I would have set up merge replication.
I believe you're right when you said, there is no problem to Transactional Replication job from
server 1 to server 2 and that's what I thought; but I wonder if anyone can answer that question for sure.
September 5, 2008 at 3:53 am
Replication will complain if it tries to replicate a delete to server 2, and your users have already deleted this data, or an insert that already exists etc.
You will need to change the replication profile to ignore these errors.
September 5, 2008 at 7:56 am
Thank you Ian,
I did not think about it.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply