Copy Site Administration database schema to the new database server

To upgrade a copy of the Site Administration database schema on a new database server machine, you must copy the schema from the database server that was used in the previous system to the database server that will be used in the new system.

You perform this step before installing 25.1 because the schema upgrade option is defined as part of the installation configuration.

Perform the required steps for backing up, removing, and restoring databases for your database type. For assistance contact your database administrator.

Note: The database user must have the same permissions as the user installing OpenText Application Quality Management.

When copying and upgrading the Site Administration database schema, ensure that the existing project refers to the production project database and shared repository, if applicable. When using a staging or side by side upgrade prior to starting the server update, update the following columns in the PROJECTS table in the Site Administration database schema to their new values:

PHYSICAL_DIRECTORY
DBSERVER_NAME
DB_CONNSTR_FORMAT
DB_USER_PASS