An administrator must upgrade the database with the DBUpgrade.exe command before upgrading the IaaS components.

The DBUpgrade command requires the names of the SQL Server database instance and the vCloud Automation Center database and the port number is you are using a port other than the default SQL port. It can use Windows authentication or it accepts credentials to access the database using SQL authentication. It creates a log file named dbupgrade.log in the current directory if you do not provide a path name for a different log file.

Important

Run this command only once during an upgrade.

Verify that the machine on which you run the DBUpgrade command meets the following Java-related requirements.

64-bit Java version 1.7 or later is installed. 32-bit versions are not supported.

The environment variable JAVA_HOME is set to the Java install folder.

The %JAVA_HOME%\bin\java.exe file is available.

1

Navigate to the Windows installer download page by using https://vcac-va-hostname.domain.name:5480/installer/, the host name of the vCloud Automation Center Appliance.

2

Click database upgrade scripts in the manual database upgrade from 6.0.1 to 6.1 item under IaaS Installation.

3

Extract the contents of the DBUpgrade.zip archive file to a local folder on the vCloud Automation Center database host, or to another location with network access to the database host.

4

In a Windows command prompt window, set your current directory to the folder where you extracted the contents of the DBUpgrade.zip archive file.

5

Enter a DBUpgrade command string in the following format.

DBUpgrade [-S dbserver[,port number][\SQLinstance]] [-d dbname] [{-E | -U username}] [-l logfilepath]

Option

Description

-S dbserver [,portnumber][\SQLinstance]

Identifies the database server instance by server name, port number and SQL instance name..

Allowable values for dbserver are localhost or a fully qualified 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 specified, the 1433 port is used.

If you are using a named SQLinstance, specify the instance name. If no name is specified, the default, unnamed SQL instance is used.

-d dbname

Identifies the vCloud Automation Center database dbname.

-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

Specifies the user name for the database owner account.

-l logfilepath

Specifies the full pathname of the upgrade log file. By default, the command creates the dbupgrade.log log file 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.

The following examples illustrate uses of command syntax.

DBUpgrade

With no options, displays usage information.

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.

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.

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 file in the VCACDBUpgrade folder on the system drive.

DBUpgrade -S dbhost.mydomain.local,5555\MySQLinstance -d VCAC -E -l %SystemDrive
%\VCACDBUpgrade\Log_30Apr.log

Upgrades the vCAC database 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 file in the VCACDBUpgrade folder on the system drive.