DataBase synchronization issues

Discussion in 'ASP .Net Web Services' started by Sinex, Apr 6, 2007.

  1. Sinex

    Sinex Guest

    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.
    Sinex, Apr 6, 2007
    #1
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Konrad

    synchronization database

    Konrad, Aug 30, 2003, in forum: ASP .Net
    Replies:
    0
    Views:
    382
    Konrad
    Aug 30, 2003
  2. Replies:
    0
    Views:
    443
  3. Dimitri Ognibene
    Replies:
    0
    Views:
    376
    Dimitri Ognibene
    Apr 25, 2006
  4. Dimitri Ognibene

    profiling and synchronization issues

    Dimitri Ognibene, Apr 27, 2006, in forum: Java
    Replies:
    0
    Views:
    339
    Dimitri Ognibene
    Apr 27, 2006
  5. Robert

    Synchronization issues

    Robert, Apr 14, 2006, in forum: Javascript
    Replies:
    7
    Views:
    105
Loading...

Share This Page