db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Maison Mo <momai...@yahoo.fr>
Subject Question on database, schemas and backups
Date Fri, 28 Jun 2013 07:07:33 GMT

For a multi-tenant application, we evaluate the multiple databases pattern and single database
/ multiple schemas pattern.
Regarding the backup process, it seems that the whole database is backed up by the SYSCS_UTIL.SYSCS_BACKUP_DATABASE(),
thus all schemas in this DB : is that correct ?
Is it then possible to restore a single schema ?

Given a jdbc client, it is possible to change schema once connection is established. Is it
also possible to change the database ?

Thank you for your answers


View raw message