IBM Rational ClearQuest installutil convertschemarepo subcommand

Description

The installutil convertschemarepo subcommand copies a schema repository to create a sample database for testing the upgrade process. The subcommand locks the production database before copying it. The installutil convertschemarepo subcommand performs the following actions:

Copies the original database to a new database.
Connects Rational® ClearQuest® to the database copy.
Locks the original database.

Important: Before running this command, use your database vendor tools to back up your databases and create new ones.

Use the unlockuserdb subcommand to unlock the production database and allow users to continue using the database while you test the copy.

Options and arguments

dbset_name: The name of the existing connection.
cq_login: The user login name for Rational ClearQuest databases that you want to copy. The user must have Super User privileges.
cq_password: The login password for the Rational ClearQuest Super User.
to_db_vendor: The new upgrade vendor database name.
to_server: The new upgrade database server name.
to_database: The new upgrade database name.
to_dbo_login: The login name of the empty database owner.
to_dbo_password: The login password of the empty database owner.
connect_options: Optional parameters, which vary by database vendor.
See Vendor database properties.
[tcpip,ipx,netbios, namedpipes]: These are optional parameters to specify networks.
[host1,host2,...]: These are optional parameters to identify multiple host computers.

Examples

Copy an Oracle schema repository named MySR. The Oracle user ID srusr, with password srPaSSWorD, exists on the target Oracle server and this user has CONNECT and RESOURCE roles. The Oracle server host name is DBServ and its Oracle system ID (SID) is ORC. The default 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 convertschemarepo admin admPaSSWorD ORACLE DBServ ORC srusr srPaSSWorD "LOB_TYPE=CLOB;PORT=1301"
```
Copy a SQL Server schema repository. The name of the SQL Server database that will hold the new copy of the schema repository is MyNewSchemaRepo. It is owned by SQL Server userid dbowner whose password is dboPaSSWorD. The target SQL Server host name is MySQLServer. The default 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 convertschemarepo admin admPaSSWorD SQL_SERVER MySQLServer MyNewSchemaRepo dbowner dboPaSSWord  "PORT=3000"
```

convertschemarepo

Applicability

Synopsis

Description

Options and arguments

Examples

See also