Make backup relative to the current location

[Christoph Läubrich]

I'm writing an upgrade script and like to make a backup from withing
that script.

Is it possible to get the name of the current database location to use
for something like this:

BACKUP TO ${current-database-location}.bak


so if my current url is 'jdbc:h2:~/maydatabase' a backup is
~/maydatabase.db.bak

[Noel Grandin]

On 2021/05/13 8:07 pm, 'Christoph Läubrich' via H2 Database wrote:
> I'm writing an upgrade script and like to make a backup from withing that script.
>
> Is it possible to get the name of the current database location to use for something like this:
>

DATABASE_PATH() is the function you want:

http://h2database.com/html/functions.html#database_path

[Christoph Läubrich]

Thanks that works like a charm :-)

Am 14.05.21 um 11:42 schrieb Noel Grandin: