Upgrading a database

To upgrade a database, you must explicitly request an upgrade the first time you connect to the database with the new version of Derby.

Ensure that you complete the prerequisite steps before you upgrade:
When you upgrade the database, you can perform a full upgrade or soft upgrade:
  • A full upgrade is a complete upgrade of the Derby database. When you perform a full upgrade, you cannot connect to the database with an older version of Derby and you cannot revert back to the previous version.
  • A soft upgrade allows you to run a newer version of Derby against an existing database without having to fully upgrade the database. This means that you can continue to run an older version of Derby against the database. However, if you perform a soft upgrade, certain features will not be available to you until you perform a full upgrade.
To upgrade the database, select the type of upgrade that you want to perform:
Type of upgrade Action
Full upgrade Connect to the database using the upgrade=true database connection URL attribute. For example:
jdbc:derby:sample;upgrade=true
Soft upgrade Connect to the database. For example:
connect 'jdbc:derby:sample'
In this example, sample is a database from a previous version of Derby.
Related tasks
Preparing to upgrade
Soft upgrade limitations