db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dag.Wan...@Sun.COM (Dag H. Wanvik)
Subject Re: AW: Alter database collation
Date Fri, 14 Aug 2009 15:09:23 GMT
Stefan Rehlig <rehlig@lemonage.de> writes:

> Hi,
> thanks for your answer. the steps for exporting/importing would be:
> 1. export all data
> 2. create new database with collation attribute
> 3. create schema in the new db without indexes nor constraints
> 4. import all data
> 5. create indexes and constraints
>
> Do I have to export/import each table separately? 

Yes, the export procedure works on the table level:

SYSCS_UTIL.SYSCS_EXPORT_TABLE

cf. 
http://db.apache.org/derby/docs/10.5/ref/rrefexportproc.html
http://db.apache.org/derby/docs/10.5/ref/rrefexportproctablelobs.html
http://db.apache.org/derby/docs/10.5/tools/ctoolsimport16245.html

Sometimes the dblook(1) tool can help recreating the schema

http://db.apache.org/derby/docs/10.5/tools/ctoolsdblook.html

although it has some limitations (YMMV):

https://issues.apache.org/jira/secure/IssueNavigator.jspa?reset=true&&query=dblook&summary=true&description=true&pid=10594&status=1&status=3&status=4&component=11414

Thanks,
Dag

Mime
View raw message