Merget Replication Issue
-
Hi,
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!
-
Hi,
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!
I have no help for you in the replication area, however this does sound like a really bad design. Some questions come to mind Why do you need the data on a local machine Why every 5 minutes
Never underestimate the power of human stupidity RAH