rollbackDatabase Task

Rolls back database changes.

rollbackDatabase task examples

<liquibase:rollbackDatabase  rollback-count="2"  changelog-file="/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"  changelog-file="/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"  changelog-file="/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
`changelog-file`	The changelog file to rollback.	Yes
`contexts`	A comma separated list of Contexts to execute. If not specified, all contexts are run.	No
`output-file`	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.
`rollback-count`	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
`log-level`	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 Substituting Properties in Changelogs