I have to develop a Web Service that basically needs to backup one database onto another. The DB vendor is not static, it is determined by the database URL given by user when it invokes the WS. This backup is online one. When the WS gets the database URL, only then can it query it for its schema. In case, the detination database doesnot have any old copy the source copy, then i can simply make an exact replica but if it has an old copy then
The problem is:
1. How do i determine what changes have been made since the last backup on the destination database(in case the destination database has an outdated copy)?
I dont think i can create triggers for the source database because the database to be backed up is not known until the Web Service invocation, its provided by user at run time.
Thank you Regards Neha (Naughty is my nick name) [ August 26, 2004: Message edited by: Naughty Yadav ]
[ August 26, 2004: Message edited by: Naughty Yadav ] [ August 27, 2004: Message edited by: Neha Yadav ]
May I ask why you are trying to do this with JDBC? All RDBMS's I can think of have back up utilities designed to run over a network, so what do you gain by reproducing this as a web service?
The easiest way I can think of to do this is to script the backup operation as a batch file for each DB and call that from Java. Most good DBA's will script their backup routines anyway. So rather than re-implementing the logic which decides what has been updated and what hasn't, which your DB probably tracks already, just call that logic by running the DB backup stuff. [ August 26, 2004: Message edited by: Paul Sturrock ]
We're pleased to have you here with us on the Ranch, but there are a few rules that need to be followed, and one is that proper names are required. Please take a look at the JavaRanch Naming Policy and adjust your display name to match it.
In particular, your display name must be a first and a last name separated by a space character, and must not be obviously fictitious.