April 20, 2009 at 12:34 am
Hi,
I am doing replication for the first time ... I need some help to understand few properties.
The requirement is as given below.
1) i have two servers , Server 1 and Server 2.
2) I need to copy the data from server 1 to server 2.
3) The replication should be such a way that , the records will be copied only when an update or Insert happens at the Server 1. But if a Delete occurs at server 1 Then the deleted record should be still available in Server 2. The server 2 basically maintains all the data till date whereas deletion of records can happen at Server 1.
Ex: If i have two records RECORD1 & RECORD2. during the first sync, both the records will be copied
Server1Server2
Record1Record1
Record2Record2
if record1 is deleted from server 1
Server1Server2
Record2Record1
.............Record2
If a new record Gets added to server 1 then data should be
Server1Server2
Record2Record1
Record3Record2
............. Record3
i Know this negates the whole purpose of replication, But will i be able to achieve it using replication.
Thanks in advance 🙂
April 20, 2009 at 9:39 am
Well I don't think it "negates" the purpose of replication in fact you are not the first trying this.
Once you have created the publication all you need to do is to Set the delete command to "none" and you are done.
With that setting no delete will be invoked on the replica server.
Good Luck
* Noel
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply