installutil copyschemarepo
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 Maintenance Tool.
- cq_login
- Logon ID of a 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:
- DB2
- ORACLE
- SQL_SERVER
- POSTGRES
Important: Vendor names must be capitalized as shown. - to_server
- Server name of the new schema repository database.
- to_database
Name of the new schema repository database. The following is vendor-specific information:
- DB2
- Database name
- Oracle
- Oracle system ID (SID)
- SQL Server
- Database name
- 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.
Example
- Copy a schema repository named MySR that uses an Oracle database server with
the CLOB data type. In this example, the Oracle SID is SID and the database
administrator and associated password are MySRadmin and
MySRpassword, respectively. The name of the new repository to copy to is
MySRcopy. The name of the Oracle user who owns the new schema repository is
MySRcopyuser and this user’s password is MySRcopypassword; this
user name and password pair is listed three times.
installutil copyschemarepo -dbset MySR MySRadmin MySRpassword ORACLE SID MySRcopy MySRcopyuser MySRcopypassword MySRcopyuser MySRcopypassword MySRcopyuser MySRcopypassword "LOB_TYPE=CLOB"