rollbackDatabase Task

Rolls back database changes.

rollbackDatabase task examples

<liquibase:rollbackDatabase  rollbackCount="2"  changelogfile="/path/to/changelog.xml">  
    <liquibase:database  driver="${db.driver}"  url="${db.url}"  user="${db.user}"  password="${db.password}"/>  
</liquibase:rollbackDatabase>

Rollback the last 2 changesets in the given changelog file.

<liquibase:rollbackDatabase  rollbacktag="my-db-tag"  changelogfile="/path/to/changelog.xml">  
    <liquibase:database  driver="${db.driver}"  url="${db.url}"  user="${db.user}"  password="${db.password}"/>  
</liquibase:rollbackDatabase>

Rollback changesets to the given tag.

<liquibase:rollbackDatabase  rollbackDate="2014-05-28"  changelogfile="/path/to/changelog.xml">  
    <liquibase:database  driver="${db.driver}"  url="${db.url}"  user="${db.user}"  password="${db.password}"/>  
</liquibase:rollbackDatabase>

Rollback changesets to the given date/time.

Parameters

Attribute	Description	Required
changeLogFile	The changelog file to rollback.	Yes
contexts	A comma separated list of Contexts to execute. If not specified, all contexts are run.	No
outputFile	If specified, Liquibase will save the rollback SQL statements to the specified file rather than executing them in the database.	No
outputEncoding	The character encoding to use when writing SQL statements to output file.	No; defaults to system encoding.
promptOnNonLocalDatabase	If set to true a dialog box with warn you if you attempt to run the Liquibase against a database that is not on localhost.	No; default is false.
classpathref	A reference to the classpath used to run the task with.	No
databaseref	A reference to the database that Liquibase will connect to.	Yes, unless a nested <database> element is present.
rollbackTag	Tag to roll back to.	Exactly one of these attributes must be provided.
rollbackDate	Date to roll back to.
rollbackCount	Number of changesets to roll back.
driver	Deprecated: Name of the database driver to connect with.	No
url	Deprecated: Use <database>'s url attribute instead. The database URL.	No
username	Deprecated:The database username to connect with.	No
password	Deprecated:The password to use when connecting to the database.	No
defaultSchemaName	Deprecated:Schema to use by default for managed database objects and Liquibase control tables.	No
currentDateTimeFunction	Deprecated: Overrides current date time function used in SQL. Useful for unsupported databases.	No
databaseChangeLogTableName	Deprecated: Overrides the name of the DATABASECHANGELOG table to use.	No
databaseChangeLogLockTableName	Deprecated: Overrides the name of the DATABASECHANGELOGLOCK table to use.	No
logLevel	Deprecated: Specifies one of the following logging levels: debug, info, warning, severe, off. The default level is info.	No

Parameters specified as nested elements

classpath

The classpath used to run the task with. Optional.

database

Required unless a databaseref attribute is given. See database data type.

changelogparameters

Optional. See changelog Property Substitution