Product Documentation

Database Integrity Utilities

Previous Topic

Next Topic

dbdeploy - Utility to deploy SP, UDF, and triggers

dbdeploy, is used to deploy stored procedures, user defined functions, and triggers to FairCom DB SQL servers that have been exported using the "dbschema -b" binary export option.

Usage:

dbdeploy [-f] [-u username] [-a authentication] [-i inputfile] [-S BASIC | <cert_filename>]

[dbsegment_name]

  • -u - Username identifiable to the DBMS.
  • -a - Password for authentication.
  • -i - Input file.
  • -f - Force overwriting of existing items.
  • -S - TLS/SSL options for secure connection:
    • BASIC - Basic TLS/SSL encryption
    • <cert_filename> - Client cross-check certificate for TLS authentication

TOCIndex