Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  SSIS and Import/Export (2005)  Replication in sql 2005

Author  Topic  tajdin Starting Member 2 Posts Posted - 2009-05-01 : 05:37:01 I have configured Replication as follows:- 1) Publication for Server1 with Database1 and Table1 2) Subscription for Server2 with Databse2 and Table1 Now when I am synchonizing, all the existing data from Server2\Databse2\Table1 gets deleted (which are not in Server1\Database1\Table1 and all data gets added in Server2\Database2\Table1 which are not there. I want to retain the Data in Server2\Database2\Tale1 and only missing date to be added from Server1\Database1\Table1 Please let me know, If this is possible? and how?