March 22, 2004 at 11:31 pm
Hi,
i had a problem . I had to take backup's from my clients database everyday and update the database in my office. the problem is my client is staying in a remote place and we didnt have any connection for their servers all we have to do is to make a back up copy them in a disk and then run them in our systems.
how can i do this ?
can anyone help me to sort out this ?
Thanks in advance.
March 23, 2004 at 1:05 am
hi Sunil Kumar
I would request you to write a small database utility which will pick up data from the tables which are inserted or updated, or deleted u may do this by keeping logs in a log table. the data picked can then be placed in a mirror copy of your database and copy to cd this process can be automated, on the other side u can write another utility to restore this data back to your main database.
We had used a similar approach for Election Data. which needed to be shipped to individual booths. and brought back to the central location after capturing.
Thank you I hope it helps you out..
Regards,
Peldin Fernandes
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply