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.