rollbackToDate command

The rollbackToDate command reverts your database to the state it was in at the date and time you specify.

Uses

The rollbackToDate command is mainly used when you want to revert all changes made to your database from today's date to the date and time you specify. The rollbackToDate command reverts those changesets to their previous state and allows you to target the date and time without impacting changes or deployments that came before the date and time you specified.

The image below shows four deployments performed at a different times: March, April, May, and February. Let's imagine that your current month is May and you want to roll back your database to March.

As you can see, the rollbackToDate command allows you to target deployment 2 performed on March 07, 2020 10:15 AM and revert all changes associated with deployments 4 through 2, to March without impacting the previous deployments—deployment 2 and 1.

Note: There are several ways to revert your changes with the rollbackToDate command. You can use YYYY-MM-DD HH:MM:SS or YYYY-MM-DD'T'HH:MM:SS formats to specify both date and time. Also, you can specify date or time only.

The impacts of rollbackToDate

The use of rollbackToDate comes with risk of removing all changes from today's date to the date you specified. Also, there is an additional impact to the DATABASECHANGELOG table. When any change is rolled back, the row associated with that change is deleted from the DATABASECHANGELOG table.

Please look for unintended consequences before using this command.

The best practice is to run the rollbackToDateSQL helper command because it allows you to inspect the rollbackToDate SQL and search for any potential mistakes before you execute the rollbackToDate command.

Running the rollbackToDate command

Before running the rollbackToDate command, run the history command to see the dates of all your previous changes.

To run the rollbackToDate command, you need to specify your driver, class path, URL, and user authentication information in your liquibase.properties file. For more information, see Creating and configuring a liquibase.properties file. You can also specify these properties in your command line.

Then run the rollbackToDate command:

liquibase --changeLogFile=sample.changelog.xml rollbackToDate 2020-05-07

Note: Enter the name of the changelog and date that you want to use in place of sample.changelog.xml and 2020-05-07.

rollbackToDate global attributes

Attribute Definition Requirement
--changeLogFile * The root changelog Required
--url The JDBC database connection URL Required
--username The database username Required
--password The database password Required

* Liquibase will check nested changelogs for definitions of the changesets to rollback.

rollbackToDate command attributes

Attribute Definition Requirement
--date/time The date and time your database rolls back to. The date format is YYYY-MM-DD HH:MM:SS or YYYY-MM-DD'T'HH:MM:SS, however, it is possible to indicate the date or time only. Required