Specifications

VMware, Inc. 163
Chapter 6 View Composer
Upgrade View Composer Database (databaseupgrade)
ThedatabaseupgradecommandisusedtoupgradeaViewComposer1.0schemato
version1.1.Inaddition,thecommandalsomigratestheinformationinthedatabase
fromViewComposer1.0toViewComposer1.1.TheschemaforViewComposerhas
notchangedsinceversion1.1.
Use Case
DuringinstallationoftheViewComposerserviceonavCenterServerwhereanolder
versionoftheserviceisalreadyinstalled,usersareofferedtheopportunitytoupgrade
theservicemanually.Ifaschemaupgradeisrequired,theymustuseSviConfigto
upgradetheschemaandmigratetheirexistingdata.
Usage
BeforeyoucanupgradetheViewComposerdatabase,youmustfirstshutdownthe
ViewComposerservicerunningonthevCenterServer.Restarttheserviceonceyou
havesuccessfullyexecutedthecommand.
SviConfigdatabaseupgradecommandinstructionsareissuedfromaWindows
commandpromptinthefollowingform:
sviconfig -operation=databaseupgrade
-DsnName=<target database source name (DSN)>
-Username=<database administrator username>
-Password=<database administrator password>
Forexample:
sviconfig -operation=databaseupgrade -dsnname=LinkedClone
-username=Admin -password=Pass
Result Output
Asuccessfuloperationresultsinthefollowingoutput:
Establishing database connection.
Database connection established successfully.
Upgrading database.
Load data from SVI_VC_CONFIG_ENTRY table.
Update SVI_DEPLOYMENT_GROUP table.
Update SVI_REPLICA table.
Update SVI_SIM_CLONE table.
SviConfig finished successfully.
Database is upgraded successfully.