Copies a schema repository.
Synopsis
- installutil copyschemarepo [-dbset dbset_name] cq_login cq_password to_db_vendor to_server to_database
to_dbo_login to_dbo_password to_rw_login to_rw_password to_ro_login to_ro_password
"connect_options"
Description
The installutil copyschemarepo subcommand
makes a copy of a schema repository. This command locks the original
schema repository for the duration of the copy operation. Once complete,
the original schema repository is unlocked.
The installutil
copyschemarepo subcommand is similar to the installutil convertschemarepo subcommand.
One difference is that the installutil convertschemarepo subcommand
keeps the original database locked after the copy operation is complete.
Also, the installutil convertschemarepo subcommand updates
the new database with the correct location information. In contrast,
the installutil copyschemarepo subcommand duplicates the original
schema repository, retaining the original location information.
All
schemas must be checked in before using the just-mentioned installutil subcommands.
Otherwise, the commands will fail with an error similar to this:
The
INSERT INTO statement contains the following unknown field name: ’field_name’.
Make sure that you have typed the name correctly, and try the operation
again.
Options and arguments
- -dbset dbset_name
- Name of the database set or database connection as it appears
in the ClearQuest Maintenance Tool.
- cq_login
- Logon ID of a ClearQuest user who has Super User privileges.
- cq_password
- Password associated with cq_login.
- to_db_vendor
- Database vendor name of the new schema repository. Available choices:
Important: Vendor names must be capitalized as
shown.
- to_server
- Server name of the new database schema. Following is vendor-specific
information:
- DB2
- User database name
- Oracle
- Oracle system ID (SID)
- SQL Server
- User database name
- to_database
- Name of the new database schema.
- to_dbo_login
- Logon ID of the new database owner.
- to_dbo_password
- Password of the new database owner.
- to_rw_login
- Logon ID of the new database owner. This value is the same as to_dbo_logon.
- to_rw_password
- Password of the new database owner. This value is the same as to_dbo_password.
- to_ro_login
- Logon ID of the new database owner. This value is the same as to_dbo_logon.
- to_ro_password
- Password of the new database owner. This value is the same as to_dbo_password.
- "connect_options"
- Optional parameters, which vary by database vendor. See Vendor database properties.