DbDeployTask

The DbDeployTask creates .sql files for making revisions to a database, based on dbdeploy conventions centering around a changelog table in the database. See rules for using dbdeploy for more information. You will need a changelog table like so:

Table 69. Attributes

Name Type Description Default Required
url String PDO connection url n/a Yes
userid String DB userid to use for accessing the changelog table none As required by db
password String DB password to use for accessing the changelog table none As required by db
dir String Directory containing dbdeploy delta scripts none Yes
outputfile String Filename in which deployment SQL will be generated dbdeploy_deploy.sql No
undooutputfile String Filename in which undo SQL will be generated dbdeploy_undo.sql No
deltaset String deltaset to check within db Main No
lastchangetoapply Integer Highest-numbered delta script to apply to db 999 No
appliedBy String Value of the 'applied_by' column for each entry in the changelog table dbdeploy No
checkall Boolean False means dbdeploy will only apply patches that have a higher number than the last patchnumber that was applied True means dbdeploy will apply all changes that aren't applied already (in ascending order) false No