Previous Topic: hmvpkg Command-Move PackageNext Topic: hmvpth Command-Move Path


hmvproj Command-Move or Copy Projects

The hmvproj is a command-line utility for the Harvest SCM Administrator usage only. This utility does not require the Harvest SCM broker connection or client components, to execute. With the specified ODBC connections to both source database and target database, the project is copied or moved between databases.

Note: This utility is packaged in the installation of Harvest SCM Server component and not available from client installation.

Important! Considering the possible impact to the existing usage, we recommend that you run this utility during off-peak time or your product maintenance period. Depending on the size of project, the copy or move project may take an extended time and database resources to complete the process of query, insert, and update in database. In addition, the verification has been bundled as a post copy project operation to assure the data integrity.

When move project is executed, the source project gets deleted after successful copy and verification of the project. Alternatively, the copy operation can be used and then specify DELETEONLY to remove it from source database.

Important! The target database has to be at same or newer Harvest SCM database schema release level than the source database. This utility returns an error, if target database’s Harvest SCM release level is older than source database.

This command has the following format:

hmvproj { -s_odbc source odbc name } { -s_usr username -s_pw password } { -t_odbc target odbc name } { -t_usr username -t_pw password } [-s_eh source encrypted filename ] [-t_eh target encrypted filename ] { -pj projectName } { -user_opt option } { -form_opt option } [-verifyonly ] [-verifyonly length ] [ -verifyrollback ] [-delete] [-deleteonly] [-h]
-S_ODBC

Specifies the ODBC name for the source project database.

-S_USR

Specifies the source database login username.

-S_PW

Specifies the source database login password.

-T_ODBC

Specifies the ODBC name of the target project database.

-T_USR

Specifies the target database login username.

-T_PW

Specifies the target database login password.

-S_EH

Specifies the source database encrypted login username/password.

-T_EH

Specifies the target database encrypted login username/password.

Note: The encrypted database credentials for both the source and target databases use the convention that the server install is supported.

-PJ

Specifies the SCM project name.

-USER_OPT

Specifies the user/user group handling option flag.

Default valid values: 0, 1, 2

0

Copy all users and user groups.

1

Copy only users and user groups, which has access to that project.

2

Ignore user and usergroup.

Note: If you select this value:

-FORM_OPT

Specifies the form handling option flag.

Default valid values: 0, 1, 2

0

Ignore form if exists in target database.

1

Overwrite form if exists in target database and source database has newer updated date.

2

Always overwrite form if exists in target database.

-DELETE

Specifies the option to delete the project in the source database after completing the copy operation.

-DELETEONLY

Specifies the option to delete the project in the source database directly without copying.

-VERIFYDATA

Specifies the option to verify the version data and the amount of data that must be compared for each version data record.

For example, specifying –VERIFYDATA=4096 indicates that the version data must be verified and that for each version data record. The data comparison is done for every 4096 bytes of total data records.

Specifying –verifydata=–1indicates that the entire version data must be compared for each record.

Note: The –verifydata option is used in a separate run of hmvproj after a project has already been copied successfully.

-VERIFYROLLBACK

Specifies the option of rolling back the copied project, if verify fails.

-SQL

Specifies the option of SQL getting copied in to the log file for debugging.