7.1

Table Of Contents
Option Description
-N
Species that a secure database connection be used. If your SQL server is
congured to accept a secure connection, you can use this option to
upgrade the database.
-E
Requires a Windows Authentication trusted connection to access the
database and connects using the Windows credentials of the user who is
running the command.
-U username
Species the user name for the database owner account.
-l logfilepath
Species the full pathname of the upgrade log le. By default, the
command creates the dbupgrade.log log le in the current directory.
6 (Optional) At the prompt, enter the password for the database owner account.
You are prompted for this information only when you specify a username with the -U username
argument to the DBUpgrade command.
The command upgrades the database to the latest release.
Example: DBUpgrade.exe
The following examples illustrate uses of command syntax.
n
DBUpgrade
With no options, displays usage information.
n
DBUpgrade -S localhost -d VCAC -E
Upgrades the VCAC database in the default, unnamed SQL instance running on the local host on the
default port 1433 and connects using your Windows credentials over a Windows Authentication trusted
connection.
n
DBUpgrade -S dbhost.mydomain.local,5555 -d VCAC -E
Upgrades the VCAC database in the default, unnamed SQL instance running on dbhost on the non-
default port 5555 and connects using your Windows credentials over a Windows Authentication trusted
connection.
n
DBUpgrade -S dbhost.mydomain.local\MySQLinstance -d VCAC -U SqlUser -l %SystemDrive
%\VCACDBUpgrade\Log_30Apr.log
Logs in as the user named SqlUser and prompts you for the password for the SqlUser account. Then,
upgrades the VCAC database in the named instance MySQLinstance running on dbhost on the default
port, and creates the Log_30Apr.log upgrade log le in the VCACDBUpgrade folder on the system
drive.
n
DBUpgrade -S dbhost.mydomain.local,5555\MySQLinstance -d VCAC -E -l %SystemDrive
%\VCACDBUpgrade\Log_30Apr.log
Upgrades the database VCAC in the named instance MySQLinstance running on dbhost and the non-
default port 5555, logs in using your Windows credentials over a Windows Authentication trusted
connection, and creates the Log_30Apr.log upgrade log le in the VCACDBUpgrade folder on the
system drive.
Upgrading from vRealize Automation 7.0 to 7.1
28 VMware, Inc.