Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > ASP .Net Web Services > DataBase synchronization issues

Thread Tools

DataBase synchronization issues

Posts: n/a
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?!

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.

Reply With Quote

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Database Database Database Database Computer Information 0 09-27-2012 02:43 AM
DataBase DataBase DataBase DataBase Computer Information 0 09-26-2012 09:40 AM
profiling and synchronization issues Dimitri Ognibene Java 0 04-27-2006 05:10 PM
how to do synchronization profiling and RepaintManager and performance issues Dimitri Ognibene Java 0 04-25-2006 09:09 AM
Facing Synchronization issues while logging Java 0 04-18-2006 07:03 AM