If you have an existing Cloudscape event database, you must upgrade
it to use the Derby database.
About this task
To upgrade a Cloudscape event
database to Derby:
Procedure
- Go to the profile_root/bin directory.
- Run the Derby migration script for your operating system:
The parameters are as follows:
- db_dir
- Specifies the path to the directory containing the existing Cloudscape event database.
This parameter is required.
- generateDDLOnly
- Specifies whether you want to generate the DDL script for upgrading
the database without running it. Specify this parameter if you want
to manually upgrade the database at a later time. This parameter is
optional; the default behavior is to generate and run the DDL script.
Results
The Derby migration script creates a backup copy of the
existing Cloudscape event
database in the
db_dir.bak directory and then creates
two DDL scripts in the database directory:
- event_newDDL.sql
- eventcatalog_newDDL.sql
If you did not specify the generateDDLOnly parameter,
the migration script automatically runs these DDL scripts to complete
the upgrade to Derby.
Example
The following example upgrades an existing Cloudscape event database in the c:\databases\cloudscapeEventDB
directory on a Windows system:
eventMigrateDerby c:\databases\cloudscapeEventDB