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"