installutil convertuserdb
Copies and relocates a user database.
Applicability
Platform: Windows
Command type: installutil subcommand
Synopsis
- installutil convertuserdb [ -dbset dbset_name] cq_login cq_password user_dbname to_user_db_vendor to_user_server to_user_database to_user_dbo_login to_user_dbo_password to_rw_login to_rw_password connect_options
Description
The installutil convertuserdb subcommand copies a user database
to create a sample database for testing the upgrade process. The subcommand
locks the production database before copying it. The installutil
convertuserdb subcommand performs the following actions:
- Locks the production database before copying it.
- Copies the original database to a new database.
- Connects Rational® ClearQuest® to the database copy.
Use the installutil unlockuserdb subcommand to unlock the production database and allow users to continue using the database while you test the copy.
Options and arguments
- -dbset dbset_name
- The name of the existing connection.
- cq_login
- The user login name to databases that you want to copy. The user must have Super User privileges.
- cq_password
- The login password for the Super User.
- user_dbname
- The name of the user database that you want to convert.
- to_user_db_vendor
- The new upgrade vendor database name. Available choices:
- DB2
- ORACLE
- SQL_SERVER
- POSTGRES
- to_user_server
- The new upgrade user database server name.
- to_user_database
- The new upgrade user database name.
- to_user_dbo_login
- The login name of the empty database owner.
- to_user_dbo_password
- The login password of the empty 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.
Examples
- Copy an Oracle user database named
DBServ that uses the CLOB data type. The Oracle user ID and password are
dbuser and dbPaSSWord, respectively, and this user ID has
CONNECT and RESOURCE roles. The Oracle system ID (SID) is ORC. The default
Rational
ClearQuest Super User ID and password are
admin and admPaSSWorD, respectively, for all databases and
schema repositories. The -dbset option is not specified because an existing schema
repository in the database set has the default name.
installutil convertuserdb admin admPaSSWorD ORACLE DBServ ORC dbuser dbPaSSWord dbuser dbPaSSWord "LOB_TYPE=CLOB;PORT=1301"
- Copy a SQL Server user database named MYDB. The
new copy of the database is named MyNewUserDB. It is also owned by SQL Server
user ID dbowner whose password is dboPaSSWorD. The target
host name is MySQLServer. The default Rational
ClearQuest Super User ID and password are
admin and admPaSSWorD, respectively. The
-dbset option is not specified because an existing schema repository in the
database set has the default name.
installutil convertuserdb admin admPaSSWorD MYDB SQL_SERVER MySQLServer MyNewUserDB dbowner dboPaSSWorD rwUser rwPassword "PORT=3000"