Database schema change between the gateway version

Products

• CA API Gateway

Issue/Introduction

Is there a way to determine if there has been a schema change, from a MSQL standpoint, between v10.1 and v11.0?

Are there changes in all the DBs like mysql, info_schema, ssg DBs, etc.

Environment

API Gateway 10.x, 11.x

Resolution

Please refer the files in the /opt/SecureSpan/Gateway/config/etc/db/ folder in v11 and upgrade_11.0.00.xml has all the changes for the database.  

In general, /opt/SecureSpan/Gateway/config/etc/db/ folder contains an xml file for the version upgraded to and that has all the changes listed in xml format.