To simplify the process of deploying SP, UDF, and triggers to multiple servers, these command-line utilities can be used to dump and deploy:
- dbschema - Dump utility option for exporting compiled SP, UDF, and triggers.
- dbdeploy (dbdeploy - Utility to deploy SP, UDF, and triggers, dbdeploy utility) - Deploy utility for loading exported SP, UDF, and triggers on other servers.
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).
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
Password Security
The dbdeploy and dbdump command-line utilities are intended to be password-friendly. However, our customers’ need for security is of great concern. Therefore, utility source code is provided and can be compiled directly into existing customer application utilities such that existing security controls can be leveraged.
Requirements to Develop and Deploy (JDK, JRE)
With the use of the dump and deploy utilities, it is no longer necessary to have both a JDK and JRE on every server.
- Develop: A JDK is required to develop and compile SP, UDF, and triggers on one server, but is not required for servers with deployed procedures.
- Deploy: A JRE is required on a server to run SP, UDF, and triggers.