S
Sinex
Hi ! Am writing a webservice that is gonna be called by another webservice
to synchronize a database. My DB has thousands of records. I dont want to
read all the records at one shot and send them across. I plan to send the
records in chunks. The problem is...what happens if i send the first chunk
and then some records get deleted on my side?!
Eg:
I send the first 5 records. Then say the 2nd record is deleted from the db.
If I blindly send records 6-10, I wouldve missed the original 6th record
(which has moved in to 5th place now due to deletion of the 2nd record!)
I have only read permissions to the DB. In this scenario, how do I make sure
that at the end of the sync operation both client and server have the same
exact DB.
to synchronize a database. My DB has thousands of records. I dont want to
read all the records at one shot and send them across. I plan to send the
records in chunks. The problem is...what happens if i send the first chunk
and then some records get deleted on my side?!
Eg:
I send the first 5 records. Then say the 2nd record is deleted from the db.
If I blindly send records 6-10, I wouldve missed the original 6th record
(which has moved in to 5th place now due to deletion of the 2nd record!)
I have only read permissions to the DB. In this scenario, how do I make sure
that at the end of the sync operation both client and server have the same
exact DB.