Migrate Database Components

Edit online

Important: The CLI commands in this section must be run in the context and order documented in Upgrading IBM webMethods 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”