5.1

Specifying a Properties File
By default, the dbextract command extracts data from the vCloud Director database using the database
connection information in the current cell's $VCLOUD_HOME/etc/global.properties file. To extract data from a
different vCloud Director database, specify the database connection properties in a file and use the
-properties option to provide the pathname to that file on the command line. The properties file is a UTF-8
file that has the following format.
username= username
password= password
servicename= db_service_name
port= db_connection_port
database-ip= db_server_ip_address
db-type= db_type
username
The vCloud Director database user name.
password
The vCloud Director database password.
db_service_name
The database service name. For example, orcl.example.com .
db_connection_port
The database port.
db_server_ip_address
The IP address of the database server.
db_type
The database type. Must be Oracle or MS_SQL .
Specifying Tables and Columns to Export
To restrict the set of data exported, use the -exportSettingsFile option and create a
data_to_export.properties file that specifies individual tables and, optionally, columns to export. This file is
a UTF-8 file that contains zero or more lines of the form TABLE_NAME:COLUMN_NAME.
TABLE_NAME
The name of a table in the database. To see a list of table names, export all tables.
COLUMN_NAME
The name of a column in the specified TABLE_NAME.
This example data_to_export.properties file exports columns from the ACL and ADDRESS_TRANSLATION tables.
ACL:ORG_MEMBER_ID
ACL:SHARABLE_ID
ACL:SHARABLE_TYPE
ACL:SHARING_ROLE_ID
ADDRESS_TRANSLATION:EXTERNAL_ADDRESS
ADDRESS_TRANSLATION:EXTERNAL_PORTS
ADDRESS_TRANSLATION:ID
ADDRESS_TRANSLATION:INTERNAL_PORTS
ADDRESS_TRANSLATION:NIC_ID
The command expects to find this file in $VCLOUD_HOME/etc/data_to_export.properties, but you can specify
another path.
Chapter 3 Upgrading vCloud Director
VMware, Inc. 39