Quick question about replication.
This was set up by a consulting company and I have been maintaining it for a customer.
THere are 2 servers - the sql server, and the app server. The sql server has a replication publication, and the app server has a replication subscription. What I need to know is, if a value changes on the app server, will it get over-written by the value on the sql server? When I went into the publication properties, it says "peer to peer" is turned off. This leads me to believe that a change on a value on the appserver will NOT update the sql server. The question I need to know though, will that change persist on the appserver? Also, if it does persist, when that same record gets changed again on the sql server, does it THEN overwrite the value on the appserver? I did some googling of replication merge - but dont know where all the settings for that are.
The obvious next question, if a change is made on the appserver, and I want to synch back to the sql server and discard the changes, how do I do that? What if I want to synch all the changes back to the sql server?