Product Documentation

Database Integrity Utilities

Previous Topic

Next Topic

dbschema - Option to dump SP, UDF, and triggers

A new option has been added to the dbschema utility that allows stored procedures, user-defined functions, and triggers to be exported so they can be deployed to other FairCom DB Servers using dbdeploy. The dbschema ‑b option is used to dump stored procedures, user defined functions, and triggers in binary format compatible with dbdeploy:

Usage:

dbschema [-d] [-b] [-u username] [-a authentication] [-o outputfile]

[-t tablenamelist] [-p procedure_name_list]

[-f function_name_list] [-T trigger_name_list]

[dbsegment_name]

  • -d - Dump the data.
  • -b - Dump stored procedures, user-defined functions, or triggers in binary format so they can be deployed using dbdeploy.
  • -o - Output file (default: screen).

TOCIndex