installutil convertschemarepo
Copies a schema repository to migrate a database for testing the upgrade process. This
subcommand updates the new database with the correct location information.
Applicability
Platform: Windows
Command type: installutil subcommand
Synopsis
- installutil convertschemarepo -dbset ora11 admin "" ORACLE 10.115.84.237 ratlutf8 emptym1 rati0nal emptym1 rati0nal emptym1 rati0nal "LOB_TYPE=CLOB"
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 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
- Name of the existing connection.
- cq_login
- User login name for Rational ClearQuest databases that you want to copy. The user must have Super User privileges.
- cq_password
- Login password for the Rational ClearQuest Super User.
- to_db_vendor
- New upgrade database server name. Available choices:
- DB2
- ORACLE
- SQL_SERVER
- POSTGRES
Important: Vendor names must be capitalized as shown. - to_server
- New upgrade database server name.
- to_database
- New upgrade-database name.
- to_dbo_login
- Login name of the empty database owner.
- to_dbo_password
- 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.
- 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.
- [tcpip,ipx,netbios, namedpipes]
- These are optional parameters to specify networks.
- [host1,host2,...]
- 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 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 convertschemarepo admin admPaSSWorD ORACLE DBServ ORC srusr srPaSSWorD srusr srPaSSWorD 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 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 convertschemarepo admin admPaSSWorD SQL_SERVER MySQLServer MyNewSchemaRepo dbowner dboPaSSWord rwuser rwPaSSWord rouser roPaSSWord "PORT=3000"