Velocity Reviews - Computer Hardware Reviews

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

Reply
Thread Tools

DataBase synchronization issues

 
 
Sinex
Guest
Posts: n/a
 
      04-06-2007
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.


 
Reply With Quote
 
 
 
Reply

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 scott93727@gmail.com Computer Information 0 09-27-2012 02:43 AM
DataBase DataBase DataBase DataBase scott93727@gmail.com 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 singh.inderjeet@gmail.com Java 0 04-18-2006 07:03 AM



Advertisments