How will upgrade from Harvest 12.5 to 13 affect custom programs that use the API?

Document ID : KB000105745
Last Modified Date : 11/07/2018
Show Technical Document Details
Question:
If you are planning an update from version 12.5 to 13 and tools have been developed to access Harvest, what is the overview of what has been changed in the database from 12.5 to 13 in order to efficiently implement these adjustments in our custom tools?
 
Answer:
Here is an overview of the changes that will be made by HDBSetup when you upgrade from SCM 12.5 to SCM v13.0.3:

v13.0.3 changes from v12.5
Tables dropped or no longer used:
HARAGASSIGNEE
HARAGASSOCPKG
HARAGASSOCPROJECT
HARAGASSOCUSER
HARAGINFO
HARAGPKGID
HARAGPRODUCT
HARAGPROJECTOPTIONS
HARAGQSYNCHUPDATES
HARAGRELEASE
HARAGREQUIREMENT
HARAGREQUIREMENTRELEASE
HARAGSPRINT
HARAGTASK
HARAGUSERSTORY
HARUSDCOMPUTERNAMES
HARUSDDEPLOYINFO
HARUSDHISTORY
HARUSDPACKAGEINFO
HARUSDPACKAGENAMES

Tables added:
HARBIGFILEDATA
HARCPMSTATE
HARCPMTEMP
HARCPMVERSIONTEMP
USCMMAPPER

Columns added to existing tables
Table: HARENVIRONMENT Column: TEMPLATEID
Table: HARPATHFULLNAME Column: PATHBYID
Table: HARVERSIONDATA Column: ISDATAINCHUNKS

The DBA will not need to make these changes, or for data view definitions dropped or added, sequences, constraints or other types of objects before the upgrade begins, because the upgrade software will do this for you.