dbExport

The dbExport utility extracts all policies from the database.

Purpose

The dbExport utility extracts all policies from the database, and places the extracted data in flat XML files. The utility creates only one XML file for each table extracted from the database.

Syntax

To invoke the dbExport utility, use the following syntax:

./dbExport

Tables exported

By default, the dbExport utility extracts the following tables from the database:

  • POLICY
  • POLICYTOALARMACTION
  • POLICYTOEMAILACTION
  • POLICYTORULE
  • RULE
  • RULEBLOB
  • RULETODEFINITION
  • RULETOCOMMANDSETACTION
  • DEFINITION
  • EVALUATION
  • COMMANDSETACTION
  • EMAILACTION
  • ALARMACTION
  • GLOBALPARAMETER
  • EXTRACTION
  • PARAMETER-GROUP
  • PARAMETERGROUPVALUE

Output

The dbExport utility creates exported XML files in the install directory, and can be found using the following path:

$(INSTALL_HOME)/db/export/tables/<tablename>.xml

Where <tablename> specifies the name of the extracted database table.