search cancel

How do we find the differences in the table structure between versions

book

Article ID: 216730

calendar_today

Updated On:

Products

CA Automic One Automation

Issue/Introduction

Within a version, is there an easy method to see if the table structure is modified for the Automation Engine?

Environment

Release : 12.3

Component : AUTOMATION ENGINE

Resolution

Ultimately, the best way to see changes in table structure between minor versions is to check the 'steps' within the db (Utility\db\oracle\12.3\steps) folder; any modifications will result in a new step. For example, as of 6/7/2021 the latest step (step 18) in 12.3 is the check/creation of an index if it isn't present. 

You can check what step you currently have in the system by doing a select * from VERSION - that will return a single value (versi_18). 

You could compare that to the latest downloaded db, and that would let you know of any sql-level changes in the system.