SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Member
    Join Date
    Jun 2004
    Location
    pakistan
    Posts
    3
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Question how to update database online while dataentery occur offline

    We make dataentry offline in our database. After completion that, we want to upload this database to online for updation with our existing online database.
    we have to do this daily.
    Please tell us such method in which only updation occur, i mean it should't be like that (the deletion of prevoius one and create new one).
    in updation case only that tables or records should be updated those are effected offline during data entry or in insertion case if any one new one table or record inserted.

  2. #2
    SitePoint Addict
    Join Date
    May 2004
    Location
    .
    Posts
    227
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    The best way of doing this, in my opinion, would be to write your own script to keep track of added records (adding a timestamp when a record was created/modified would help) and a synchronisation one.
    Ilya Devyatovsky
    ThinkHost, Inc.
    Wind/solar powered web hosting - 6 months free!


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •