installutil convertschemarepo

Copies a schema repository to create a sample 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 HCL Compass 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 HCL Compass databases that you want to copy. The user must have Super User privileges.
cq_password
Login password for the HCL Compass Super User.
to_db_vendor
New upgrade vendor database name.
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.
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 HCL Compass 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 HCL Compass 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"