db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dyre Tjeldvoll <Dyre.Tjeldv...@oracle.com>
Subject Re: Question on database, schemas and backups
Date Fri, 28 Jun 2013 08:28:08 GMT
On 06/28/13 09:07 AM, Maison Mo wrote:
> Hello,
>
> 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 ?

I believe so, yes.

> Given a jdbc client, it is possible to change schema once connection is established.

SET SCHEMA,

See
http://db.apache.org/derby/docs/10.10/ref/rrefsqlj32268.html

 > Is it also possible to change the database ?

I think you need to create a new connection to the new database.


Regards,
Dyre

Mime
View raw message