update-one-changeset-sql

Note: This is a Liquibase Pro command, so you need a Liquibase Pro License Key to use it.

The update-one-changeset-sql command is a helper command that allows you to inspect the SQL Liquibase will run to deploy the changeset specified in the update-one-changeset command. It is only available for Liquibase Pro users.

Uses

The update-one-changeset-sql command is useful when you want to inspect the raw SQL that Liquibase uses to deploy your changeset when you run the update-one-changeset command, so that you don't unintentionally make a mistake.

Running the update-one-changeset-sql command

Before running the update-one-changeset-sql command, gather the following information from your changelog:

  • The author of the changeset you want to deploy
  • The ID of the changeset you want to deploy
  • The file name (changeset path) of the changeset you want to deploy

Then run the update-one-changeset-sql command, with your information:

liquibase update-one-changeset-sql --changeset-id=2 --changeset-author=anotherdev --changeset-path=example-changelog.sql

For more command specific help, type liquibase update-one-changeset-sql --help into the command prompt.

update-one-changeset-sql global attributes

Tip: All commands and parameters use the --kebab-case format in the CLI environment. This is the format Liquibase recommends for best results. If your preference is camelCase, it will still work in the CLI.

Parameter Definition Requirement
--changelog-file

The root changelog

Required
--url

The JDBC database connection URL

Required
--username

The database username

Required
--password

The database password

Required
--liquibaseProLicenseKey

Your Liquibase Pro license key

Required
--output-file

Specifies the file path to where the SQL output will be written

Optional *

Note: The username and password attributes are not required for connections and systems which use alternate means of authentication.

* If not specified, the SQL output goes to STDOUT.

update-one-changeset-sql command attributes

Parameter Definition Requirement
--changeset-id

The changeset ID from the changelog.

Required
--changeset-author

The name of the author for the changeset.

Required
--changeset-path

The path to the changelog containing the changeset you want to roll back.

Required

Like what you see? Try this command in Pro for Free.