How to check ssg database changes between different gateway versions

Products

• CA API Gateway

Issue/Introduction

the customer wonder if he can receive the table specification on MySQL of both version 10.x and 11.0 because this customer has developed some customized logic with querying data in MySQL directly on Layer7 API Gateway 10.x and should also migrate this logic in this upgrading. 

 

Environment

Release : 11.0

Resolution

Check the /opt/SecureSpan/Gateway/config/etc/db/upgrade_<version>.xml file.

 

For example, 

# cat /opt/SecureSpan/Gateway/config/etc/db/upgrade_11.0.00.xml 
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<databaseChangeLog xmlns="http://www.liquibase.org/xml/ns/dbchangelog"
                   xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
                   xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.2.xsd"
                   logicalFilePath="upgrade_11.0.00.xml">
    <changeSet author="gateway" id="update_ssg_version">
        <update tableName="ssg_version">
            <column name="current_version" value="11.0.00"/>
        </update>
        <rollback>
            <update tableName="ssg_version">
                <column name="current_version" value="10.1.00"/>
            </update>
        </rollback>
    </changeSet>
</databaseChangeLog>