Migrate from MySQL to Embedded Database
search cancel

Migrate from MySQL to Embedded Database

book

Article ID: 367059

calendar_today

Updated On:

Products

CA API Gateway

Issue/Introduction

Moving from an appliance gateway to a software gateway for the version 11 upgrade in our Dev environment. 

The appliance is using mysql as the SSG DB we want to use the embedded database in this environment

 

Environment

Gateway 10.1 and Gateway 11.0

Resolution

This is not a common upgrade deployment  “mysql to embedded database”

Recommend review the GMU java utility that can be used to migrate all

https://techdocs.broadcom.com/us/en/ca-enterprise-software/layer7-api-management/api-gateway/11-0/gateway-migration.html 

Example of the steps 

  1. Source: Gateway (GW)   gmu migrateOut --argFile args/sourceGW.properties --trustCertificate  --trustHostname --all -d destination/gw-11-0-all.xml
  2. Setup and configure software GW 11 - using embedded db (must be operational and running)
  3. Policy manager installing the license and Restman
  4. gmu migrateIn --argFile args/destinationGW.properties --trustCertificate  --trustHostname --all -d destination/gw-11-0-all.xml  -test  (NOTE test first)
  5. Resolve all conflicts using manageMappings
  6. Migrate In  gmu migrateIn --argFile args/destinationGW.properties --trustCertificate  --trustHostname --all -d destination/gw-11-0-all.xml