Database Integrity Utilities

Utilities for Stored Procedures, User-Defined Functions & Triggers

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.

In This Chapter dbschema - Option to dump SP, UDF, and triggers dbdeploy - Utility to deploy SP, UDF, and triggers Password Security Requirements to Develop and Deploy (JDK, JRE)