copyuserdb

Copies a user database.

Synopsis

installutil copyuserdb

[-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 copyuserdb subcommand makes a copy of a user database. This command locks the original database for the duration of the copy operation. Once complete, the original database is unlocked.

The installutil copyuserdb subcommand is similar to the installutil convertuserdb subcommand. One difference is that the installutil convertuserdb subcommand keeps the original database locked after the copy operation is complete. Also, the installutil convertuserdb subcommand updates the new database with the correct location information. In contrast, the installutil copyuserdb subcommand duplicates the original database, retaining the original location information.

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 user database. Available choices:
  • DB2
  • ORACLE
  • SQL_SERVER
Important: Vendor names must be capitalized as shown.
to_server
Server name of the new user database. 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 user database.
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 user database named MyDB 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 MyDBadmin and MyDBpassword, respectively. The name of the new database to copy to is MyDBcopy. The name of the Oracle user who owns the new database is MyDBcopyuser and this user’s password is MyDBcopypassword; this user name and password pair is listed three times.

    installutil copyuserdb -dbset MyDB MyDBadmin MyDBpassword ORACLE SID MyDBcopy
    MyDBcopyuser MyDBcopypassword MyDBcopyuser MyDBcopypassword MyDBcopyuser MyDBcopypassword
    "LOB_TYPE=CLOB"

See also

copyschemarepo, convertuserdb, convertschemarepo

Parent topic: Rational ClearQuest command reference
Feedback