The DBDeploy plugin enables Deployment Automation to upgrade a database.
To use the plugin's step, open the process designer and navigate to Database > DBDeploy in the Tool's pane.
This plugin has the Run DbDeploy Step which you may use to upgrade your database.
To create a Run DbDeploy step:
- Enter a name for your Run DbDeploy step.
Specify values for the following required properties:
Property Description Driver Classname Class name of the driver for the database. DB Driver Jar Base Path Location of the DB driver jar files. DB Driver Jars Name of the database driver .jar file. Supports the asterisk (*) wildcard. URL Database URL, for example, jdbc:hsqldb:hsql://localhost/xdb. User Username for the database login. Password Password for the username for the database login. SQL File path The path to the directory within which the SQL files reside. Changelog table name Name of the change log table to use. This is useful if the DDL and DML need to be separate when deploying to replicated environments. SQL statement delimiter The delimiter to use to separate scripts into statements. Default is a semicolon (;). SQL statement delimiter type To split on the delimiter whenever it occurs, specify normal. To split on the delimiter only if it is featured on a line by itself, specify row. Default is normal. Line Ending How lines should be separated in SQL statements that are issued by way of JDBC. By default, the step uses the appropriate line ending for the platform it is running on and this is normally satisfactory. However, due to a bug in some Oracle drivers, the Windows default of
CRLFmay not always work.
This property takes the values:
(Optional) Specify the following:
The Output File property can be used to switch to output script mode. The name of the script that DBDeploy outputs. This should include a full or relative path.
The DB Type is required if script mode is used. This refers to the target DBMS.
The Template Directory is the directory from which to read customized template scripts. This is relevant only in script mode.