The queries below will allow you to see all the migration history of a particular CAST database, as well as check the migration history for a specific CAST database type (local, central, or management).
Release | Yes/No |
|---|---|
| 8.3.x |  |
| 8.2.x | |
| 8.1.x | |
| 8.0.x | |
| 7.3.x | |
RDBMS | Yes/No |
|---|---|
| Oracle Server |  |
| Microsoft SQL Server | |
| CSS3 | |
| CSS2 | |
Use the query below to check the general migration history information for all components of a database. Ignore results whose revision is '-1.-1.-1.-1'
SELECT * FROM sys_package_history;
"CORE_PMC";"8.2.0.1375";0;"2017-01-12 20:17:35.331";"CAST 8.2.0 ( Build 1375 )"
"PMC";"7.3.0.1";0;"2017-01-12 20:17:35.334";"CAST 8.2.0 ( Build 1375 )"
The query results above will list the history of all components, their versions, the date of the installation, and the installer used during the installation.
Be careful in examining these as some components may not have values that correspond to the CAST version number, like the PMC component does in the results above.
If you are not familiar with the results returned, you may want to try the query below which will provide a more simple result for examination by comparing just one component on a database over the history of the migration.
Use the Query Below to check the migration history of a particular central, local, or management CAST database. For local, replace XXXXX in the query below with ADG_LOCAL_APPW; For central, replace XXXXX in the query below with ADG_FULL_CENTRAL; For management, replace XXXXX in the query below with PMC_MAIN
SELECT package_name ,
revision ,
revision_type,
revision_date,
installer
FROM sys_package_history
WHERE package_name = 'XXXXX'
AND revision != '-1.-1.-1.-1'
"ADG_FULL_CENTRAL";"7.0.5.1";0;"2012-04-16 09:19:29.062";"CAST 7.0.5 ( Build 3708 )"
"ADG_FULL_CENTRAL";"7.0.8.1";0;"2012-10-02 10:39:38.274247";"CAST 7.0.8 ( Build 3998 )"
"ADG_FULL_CENTRAL";"7.3.5.1";0;"2016-02-01 15:55:03.658702";"CAST 7.3.5 ( Build 7496 )"
"ADG_FULL_CENTRAL";"8.2.1.1";0;"2017-03-08 13:01:07.103";"CAST 8.2.1 ( Build 1425 )"
Enter the SQL query
Enter the SQL query
