db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Stefan Rehlig" <reh...@lemonage.de>
Subject AW: Alter database collation
Date Thu, 13 Aug 2009 08:34:20 GMT
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: Dag.Wanvik@Sun.COM [mailto:Dag.Wanvik@Sun.COM] 
Gesendet: Mittwoch, 12. August 2009 19:42
An: Derby Discussion
Betreff: Re: Alter database collation

Stefan Rehlig <rehlig@lemonage.de> 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


Mime
View raw message