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

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.