installutil copyuserdb
Copies a user database.
Synopsis
- installutil copyuserdb [-dbset dbset_name] cq_login cq_password SourceUserDB 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 copyuserdb subcommand makes a copy of a user database. This command locks the original database for the duration of the copy operation. Once complete, the original database is unlocked.
The installutil copyuserdb subcommand is similar to the installutil convertuserdb subcommand. One difference is that the installutil convertuserdb subcommand keeps the original database locked after the copy operation is complete. Also, the installutil convertuserdb subcommand updates the new database with the correct location information. In contrast, the installutil copyuserdb subcommand duplicates the original database, retaining the original location information.
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.
- SourceUserDB
- The user database that is to be copied.
- to_db_vendor
- Database vendor name of the new user database. Available choices:
- SQL_SERVER
Important: Vendor names must be capitalized as shown. - to_server
- Server name of the new user database.
- to_database
-
Name of the new user 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.