With the SviConfig command-line utility, you can upgrade the View Composer database separately from the View Composer software. This utility also creates a log file to simplify troubleshooting if the upgrade fails.

No database schema changes have been made between View Composer 2.0.x, 2.5.x, or 2.6.x and View Composer 2.7. If you are upgrading from one of these releases, you do not need to perform this procedure.

Important

Only experienced View Composer administrators should use the SviConfig utility. This utility is intended to resolve issues relating to the View Composer service.

Back up the View Composer database. For instructions, see the documentation for your database server.

1

On the vCenter Server virtual or physical machine, open a Windows command prompt and navigate to the SviConfig executable file.

The file is located with the View Composer application.

Option

Action

32-bit Windows

Navigate to C:\Program Files\VMware\VMware View Composer\sviconfig.exe.

64-bit Windows

Navigate to C:\Program Files (86)\VMware\VMware View Composer\sviconfig.exe.

2

Enter the command to stop the VMware View Composer service.

net stop svid

3

Run the SviConfig databaseupgrade command.

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

A successful operation displays output that shows the upgrade steps.

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.
4

Enter the command to start the VMware View Composer service.

net start svid

A complete log of the upgrade process is created.

Option

Description

Windows Server 2003

C:\Documents and Settings\All Users\Application Data\VMware\View Composer\Logs\vmware-sviconfig.log

Windows Server 2008

C:\Users\All Users\VMware\View Composer\vmware-sviconfig.log

If the database upgrade fails, see Troubleshooting a View Composer Database Upgrade Failure.

If the result code is any number other than 0, which means success, see Result Codes for a Manual Database Schema Update.