Complete Installation and Upgrade Information for Software AG Products : Command Central : Command Central Developer Reference : Using the Command Line Interface : Managing Database Components Using CLI Commands : Migrate Database Components
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”
Copyright © 2007-2017 Software AG, Darmstadt, Germany.

Product LogoContact Support   |   Community   |   Feedback