Migrate Database Components
Important:
The CLI commands in this section must be run in the context and order documented in Upgrading Software AG Products. Otherwise, you will experience unpredictable results, possibly including corruption of your installation and data.
To migrate the database components for a product:
sagcc exec administration product local DatabaseComponentConfigurator
database migrate db.type=db_type
{product|component}=productID|componentID
version=dest_version db.username=db_username db.password=db_password
db.name=db_name db.url=db_url
To migrate the database components for a product from a specific version:
sagcc exec administration product local DatabaseComponentConfigurator
database migrate db.type=db_type
{product|component}=productID|componentID
version=dest_version fromversion=src_version db.username=db_username
db.password=db_password db.name=db_name db.url=db_url
Example
To upgrade the database components for the product with ID “IS” from version “9.9.0.0” to the latest version, on the SQL server at URL “jdbc:wm:sqlserver://DBserver:1433;databaseName=TESTDB”, and for the database user “webmuser” with password “webmpass”:
sagcc exec administration product local DatabaseComponentConfigurator
database migrate db.type=sqlserver product=IS version=latest
fromversion=9.9.0.0 db.username=webmuser
db.password=webmpass db.name=TESTDB
db.url=“jdbc:wm:sqlserver://DBserver:1433;databaseName=TESTDB”
To upgrade the database component with code “STR” to the latest version, on the SQL server at URL “jdbc:wm:sqlserver://DBserver:1433;databaseName=TESTDB”, and for the database user “webmuser” with password “webmpass”:
sagcc exec administration product local DatabaseComponentConfigurator
database migrate db.type=sqlserver component=STR version=latest
db.username=webmuser db.password=webmpass db.name=TESTDB
db.url=“jdbc:wm:sqlserver://DBserver:1433;databaseName=TESTDB”