db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Kathey Marsden <kmarsdende...@sbcglobal.net>
Subject Re: Migrating CLOBs to new DB schema
Date Wed, 05 Jul 2006 23:03:51 GMT
John English wrote:

> I have a database where I need to change the schema for a couple of 
> crucial
> tables. This involves changing the types of some fields, so I can't 
> just do
> an "alter table". The tables contain CLOBs, so I can't use the 
> provided SYSCS
> export/import procedures.

[snip what John tried]

>
> Any other ideas that I could try?
>
I had great luck recently with DDLUtils.  I hit one small issue with 
zero length Clobs which I think is resolved now.
http://db.apache.org/derby/integrate/db_ddlutils.html

Kathey



Mime
View raw message