Database schema change between the gateway version
search cancel

Database schema change between the gateway version

book

Article ID: 275849

calendar_today

Updated On:

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

Cause

User may need to know what has been changed in the database after the upgrade. 

Resolution

Please refer the files in the /opt/SecureSpan/Gateway/config/etc/db/ folder in v11.x and upgrade_11.x.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.