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:[EMAIL PROTECTED]
Sent: Wednesday, February 01, 2006 7:39 PM
To: [email protected]
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
