Using DataPort for backup, restore & repair

[Øyvind Harboe <oy...@zylin.com>]

I'm thinking about using DataPort to create backups & restore.

I'm adding an admin web-interface to my application to download
backups of the underlying database.

I'll then programmatically use DataPort to generate a HSQLDB or Derby
database, zip it up and let the admin download this .zip file. The
databases in my application are small(<500Mbyte for all forseable
future), so this should be fine.

Already it is apparent that DataPort is not tailored for this purpose
so my plan is to duplicate and mofiy DataPort for my purposes(backup,
restore & repair).

What I'd really like is to have the backup be a single large manually
editable file(XML?) and also have some repair utilities(to fix bugs in
the data such as duplicate primary keys, foreign key references to
non-existent objects, etc.)

W.r.t. restore, I haven't quite understood whether DataPort will be
able to restore databases where circular foreign key relationships
exist, but I'm going to be doing some more testing there.

-- 
Øyvind Harboe
http://www.zylin.com