Bjorkman wrote:

>
>
> Hello,
> I currently have a java application using another database as an embedded db.
> I'm looking for replacement.
>
> The benefits of current db:
>
> 1) Embedded (just copying files into proper directory at install)

For the software to run it - yes just copy firebird files

> 2) My install use a DB already setup with tables and some initial values
> 3) If a client has problems with the SW they can send the db (4 files) to me and
> I can test with their DB in my develop environment.
> 4) If I find a problem with the DB I can update and send back to them

The database is a single file. While one can simply copy it, it makes more sense
to use the backup and restore functions to compress the data and rebuild indexes
when restoring.
My own systems use a database per website which gets automatically backed up
each night - something which can be run while the site is live! - and then
copied to the storage area for duplicating to another machine.

> 5) There is a good GUI SQL Browser with the project to work with the DB (setting
> up tables, running sql-script files, adding users, etc.)

http://www.flamerobin.org/ except users are not used for the embedded server,
they form part of a full server which has it's own user database.

--
Lester Caine - G8HFL
-----------------------------
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk
Rainbow Digital Media - http://rainbowdigitalmedia.co.uk