7.1

I The DBUpgrade.exe command is case-sensitive. Enter the command line options using the case
shown in the command options table.
Run this command only once during an upgrade.
If Java 8, update 91, 64 bit is not installed, or if the JAVA_HOME environment is set incorrectly, you see a
message similar to the following one:
Upgrading VMware vCAC or vCloud Automation Center IaaS SQL database
fails with the error: Java version 1.7(64-bit) must be installed,
the environment variable JAVA_HOME must be set to the Java install folder, and
%JAVA_HOME%\bin\java.exe (2089329)
For information about resolving the error, see the VMware Knowledge Base article at
hp://kb.vmware.com/kb/2089329.
Prerequisites
n
Verify that the machine on which you run the DBUpgrade command meets the following Java-related
requirements.
n
Java 8, update 91, 64 bit, jdk-8u91-windows-x64.exe, is installed. 32-bit versions are not supported.
For the latest version information, see the vRealize Automation Support Matrix at
hps://www.vmware.com/support/pubs/vcac-pubs.html.
n
The environment variable JAVA_HOME is set to the Java install folder.
n
The %JAVA_HOME%\bin\java.exe le is available.
Procedure
1 Navigate to the Windows installer download page by using hps://vcac-va-hostname.domain.name:
5480/installer/, the host name of the vRealize Automation appliance.
2 Click database upgrade scripts from the list of options under IaaS Installation.
3 Extract the contents of the DBUpgrade.zip archive le to a local folder on the vRealize Automation
database host, or to another location with network access to the database host.
4 In an elevated Windows command prompt window, set your current directory to the folder where you
extracted the contents of the DBUpgrade.zip archive le.
5 Enter a DBUpgrade command string in the following format, recognizing that the command options are
case-sensitive.
DBUpgrade [-S dbserver[,port number][\SQLinstance]] [-d dbname] [-N] [{-E | -U username}] [-
l logfilepath]
Option Description
-S dbserver [,portnumber]
[\SQLinstance]
Identies the database server instance by server name, port number and
SQL instance name.
Allowable values for dbserver are localhost or a fully qualied domain
name for the database server.
If you are using an SQL port number other than the default, 1433, you
must specify the port number as part of the FQDN. If no port number is
specied, the 1433 port is used.
If you are using a named SQL instance, specify the instance name. If no
name is specied, the default, unnamed SQL instance is used.
-d dbname
Identies the vRealize Automation database dbname.
Chapter 4 Upgrading the IaaS Server Components
VMware, Inc. 27