I am trying to make Merge Replication for my .NET application and I manged to set it up but I have an issue. I am making the replication every 5 minutes where the publisher and the distributor are on the server and the subscriber on a local machine. Also, I am using pull type subscriber. Inside my .NET application I am accessing the data from my local machine(subscriber), but during the replication process,the data on the subscriber gets deleted which causes a problem to my .NET application and the end user cannot find his/her information because it being deleted and re-inserted into the subscriber later on. This is a serious issue because I am building a POS application and the user need the data instantly.
My questions, is there a way to make the subscriber to do make the pull data without deleting the current data? any idea is very welcome.
Thank you! :-)