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. Advertisements

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. Larry Maturo
    Replies:
    1
    Views:
    561
    Jason Newell
    Nov 4, 2005
  2. Konrad

    synchronization database

    Konrad, Aug 30, 2003, in forum: ASP .Net
    Replies:
    0
    Views:
    446
    Konrad
    Aug 30, 2003
  3. Replies:
    0
    Views:
    522
  4. Dimitri Ognibene
    Replies:
    0
    Views:
    520
    Dimitri Ognibene
    Apr 25, 2006
  5. Dimitri Ognibene

    profiling and synchronization issues

    Dimitri Ognibene, Apr 27, 2006, in forum: Java
    Replies:
    0
    Views:
    425
    Dimitri Ognibene
    Apr 27, 2006
  6. Replies:
    4
    Views:
    1,494
  7. Goran Djuranovic

    Wireless database synchronization and upload

    Goran Djuranovic, Feb 13, 2004, in forum: ASP .Net Mobile
    Replies:
    1
    Views:
    196
    Ed Kaim [MSFT]
    Feb 13, 2004
  8. Robert

    Synchronization issues

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