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
changeLogFile

The changelog file for Liquibase to use.

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 update SQL statements to the specified file rather than executing them in the database.

No
outputEncoding

The character encoding to use when writing 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

Attribute Description Required
classpath

The classpath used to run the task.

Optional
database

See database data type for more information.

Required unless a databaseref attribute is given.
changelogparameters

See Substituting Properties in Changelogs for more information.

Optional