I need to replicate data from server A to server B, server A is for transactional use, while server B is for reporting, where we do some database modification, for example posting, the problem is everytime the replicate agent run, it reset the modification into the original data. and when I opt "Keep the existing table unchanged", the replication will fail or only run 1 time, from 6 times scheduled replication agent run.
example table modification :
Server A
Table Invoice
ID : 01
Date : 2008/08/10
Client : ABC
Flag : 0
Server B
Table Invoice
ID : 01
Date : 2008/08/10
Client : ABC
Flag : 1
can anyone tell me what option should I choose? do I need to mention row Filters or anything? any help appreciated, thx