ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Harvest Archive utility

book

Article ID: 41297

calendar_today

Updated On:

Products

CA Harvest Software Change Manager - OpenMake Meister

Issue/Introduction

Question:

Is there any way to remove/free space in our database ?

 

Environment:

Harvest 12.5 and 12.6

 

Resolution:

Please review Harvest Archive utility. 

CA_SCM_Admin_ENU.pdf - page 157 Project Archive/Restore Utility 

CA_SCM_Ref_ENU.pdf - page 20 har Command-Archive 

 

In summary, you can archive old projects that you no longer use. Archive frees up tablespace in the database that can be reused by other projects. 

You may not see immediate saving in disk space until you run a shrink on the database to reclaim space. 

There are also certain rules that apply to projects that you will see in the Reference Guide above. 

Also a note, if you have archived projects, it is REQUIRED to restore all of the archived projects before you can run any SCM db upgrade script. This is a known limitation on the current archive/restore utility.

 

Starting in Harvest 12.5, we now have a new utility that allows users to move a project database from one database to another for performance or space purposes.

Check hmvproj 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. For further reading, please see our techdoc TEC1488565 or our online guides https://docops.ca.com/ca-harvest-scm/13-0/en

 

Environment

Release: SCMNCR99000-12.5-Harvest-Software Change Manager-Named User-Competitive Replacem
Component: