installutil copyuserdb
Synopsis
- installutil copyuserdb [-dbset dbset_name] cq_login cq_password SourceUserDB 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 Maintenance Tool.
- cq_login
- Logon ID of a user who has Super User privileges.
- cq_password
- Password associated with cq_login.
- SourceUserDB
- The user database that is to be copied.
- to_db_vendor
- Database vendor name of the new user database. Available choices:
- DB2
- ORACLE
- SQL_SERVER
- POSTGRES
Important: Vendor names must be capitalized as shown. - to_server
- Server name of the new user database.
- to_database
Name of the new user 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.
- "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
twice.
installutil copyuserdb -dbset MyDB MyDBadmin MyDBpassword ORACLE SID MyDBcopy
MyDBcopyuser MyDBcopypassword MyDBcopyuser MyDBcopypassword.
"LOB_TYPE=CLOB"