Changing a database association to a different schema

After a user database is associated with a schema, you cannot apply a new schema to the database. You can upgrade a database only with newer versions of the same schema.

For example, if a user database uses version 1 of the DefectTracking schema, you can upgrade that database to version 2 of the DefectTracking schema, but you cannot upgrade to the Enterprise schema.

However, you can move the data in an existing user database to a new database that is associated with a new schema. To do so, you must create a new database and associate it with the new schema. Then, you can use HCL Compass tools to export the data from the old database and import it into the new one.

You can use the command-line utility, cqload, and the import and export functions, to copy all or part of a schema into another schema repository. For more information, see Importing and exporting data and the command line reference pages.