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? Do you have any guidelines/experience for exporting/importing a whole database? Thx for your help Stefan -----Ursprüngliche Nachricht----- Von: [email protected] [mailto:[email protected]] Gesendet: Mittwoch, 12. August 2009 19:42 An: Derby Discussion Betreff: Re: Alter database collation Stefan Rehlig <[email protected]> writes: > we’re using derby in one of our products. With the new version of > our product we are facing a collation problem. For creating new > databases on application setup we use the collation option > TERRITORY_BASED. Older versions of our app did not use the collation > parameter. So we need to find a way for altering the collation of > these existing databases to territory based. Do you see any way to > achieve this? Could you side-step the issue using export/import? Dag
