history
command
The history
command is a helper command that lists out all your deploymentIds
and all changesets associated with each deploymentId
.
Uses
The history
command is typically used when you want to inspect a particular group of changes to ensure that they have been applied to the database.
Running the history
command
Before running the history
command, make sure you specify your url
, username
, and password
information in your liquibase.properties
file or through the command line.
To run the history
command, type the following in to your command prompt:
liquibase --outputFile=history.txt history
history
global parameters
Parameter | Definition | Requirement |
---|---|---|
--url | The JDBC database connection URL | Required |
--username | The database username | Required |
--password | The database password | Required |
--outputFile | Specifies that the output should go to a file rather than to STDOUT |
Optional |
Output
When successful, the history
command produces the following output:
C:\dev\DaticalDB-testing\liquibase-pro-cli-project\oracle_lbpro_master>..\liquibase history
Liquibase Pro 3.8.7 by Datical licensed to Liquibase Pro Customer until Tue Nov 03 19:00:00 CST 2020
Liquibase History for jdbc:oracle:thin:@3.219.82.47:1521/orcl - Database updated at 2/17/20 10:54 AM. Applied 3 changeSet(s) in 0.485s, DeploymentId: 1958497040
oracle_lbpro_master_changelog.xml::1::createTableforSynonym-PROSCHEMA::Liquibase Pro User
oracle_lbpro_master_changelog.xml::2::createTableForView-PROSCHEMA::Liquibase Pro User
oracle_lbpro_master_changelog.xml::3::createTableForCC-PROSCHEMA::Liquibase Pro User
Liquibase command 'history' was executed successfully.