installutil convertuserdb

Copies a user database 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 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 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 HCL Compass 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.
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.
connect_options
Optional parameters, which vary by database vendor.

See Vendor database properties.

Examples

  • 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 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 convertuserdb admin admPaSSWorD MYDB SQL_SERVER MySQLServer MyNewUserDB dbowner dboPaSSWorD "PORT=3000"