installutil copyschemarepo

Copies a schema repository.

Synopsis

installutil copyschemarepo [-dbset dbset_name] cq_login cq_password to_db_vendor to_server to_database to_dbo_login to_dbo_password to_rw_login to_rw_password to_ro_login to_ro_password "connect_options"

Description

The installutil copyschemarepo subcommand makes a copy of a schema repository. This command locks the original schema repository for the duration of the copy operation. Once complete, the original schema repository is unlocked.

The installutil copyschemarepo subcommand is similar to the installutil convertschemarepo subcommand. One difference is that the installutil convertschemarepo subcommand keeps the original database locked after the copy operation is complete. Also, the installutil convertschemarepo subcommand updates the new database with the correct location information. In contrast, the installutil copyschemarepo subcommand duplicates the original schema repository, retaining the original location information.

All schemas must be checked in before using the just-mentioned installutil subcommands. Otherwise, the commands will fail with an error similar to this:

The INSERT INTO statement contains the following unknown field name: ’field_name’. Make sure that you have typed the name correctly, and try the operation again.

Options and arguments

-dbset dbset_name
Name of the database set or database connection as it appears in the Maintenance Tool.
cq_login
Logon ID of a user who has Super User privileges.
cq_password
Password associated with cq_login.
to_db_vendor
Database vendor name of the new schema repository. Available choices:
  • SQL_SERVER
Important: Vendor names must be capitalized as shown.
to_server
Server name of the new schema repository database.
to_database

Name of the new schema repository database. The following is vendor-specific information:

SQL Server
Database name
to_dbo_login
Logon ID of the new database owner.
to_dbo_password
Password of the new 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.

See also

installutil copyuserdb, installutil convertschemarepo, installutil convertuserdb