db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rick Strong <rstr...@panix.com>
Subject RE: Migrating Ancient Cloudscape DBs To Derby
Date Fri, 03 Feb 2006 16:39:41 GMT
A lot of data in there (3.6)  is stored as java instances (old 
Cloudscape method) - would this
method work with data like that? It's now being treated similarly, but 
the object storage is
now implemented as BLOBs.

>Why not just copy the schema then unload each table and then load each
>table.
>
>Yeah its not elegant, and its brute force, but it will get the job done.
>
>
>  
>
>>> -----Original Message-----
>>> From: Rick Strong [mailto:rstrong@panix.com]
>>> Sent: Wednesday, February 01, 2006 7:39 PM
>>> To: derby-user@db.apache.org
>>> Subject: Migrating Ancient Cloudscape DBs To Derby
>>> 
>>> Greetings,
>>> 
>>> I am attempting to migrate some very old Cloudscape databases (v. 3.6)
>>> to Derby.
>>> 
>>> It appears that I have to first migrate from Cloudscape 3.6 to
>>> Cloudscape 5.1; this step seems to be a matter of opening the database
>>> using Cloudscape 5.1 and including "upgrade=true" in the connection URL.
>>> Problem: I don't have a copy of 5.1. Is this available anywhere?
>>> 
>>> The next step seems to be to use the IBM migration kit that is
>>> apparently able to take a Cloudscape 5.1 database to the Cloudscape 10.x
>>> level. Would there be any problem using the upgraded database with the
>>> current version of Derby?
>>> 
>>> Is there any more direct way to take the database from Cloudscape 3.6 to
>>> Derby 10.X?
>>> 
>>> Thanks for any help!
>>> 
>>> Regards,
>>> 
>>> Rick Strong
>>    
>>

Mime
View raw message