Stefan Rehlig <[email protected]> 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
