9.12.4 changelog-sync-to-tag

Marks all undeployed changesets as executed starting from the top of the changelog file and moving down up to and including the tag.

Syntax

Liquibase|lb changelog-sync-to-tag|chstt {OPTIONS}

Options

Option	Description	Default
Required
-changelog-file|-chf	The root changelog file.	-
-tag|-ta <tag>	The tag to be used during the execution of command.	-
Optional
-contexts|-co	Context string to use for filtering which changes to operate on.	-
-database-changelog-table-name|-dactn	Name of table to use for tracking change history.	-
-debug|-de	Enable debug output.	-
-default-schema-name|-desn	The default schema name to use for the database connection.	-
-defaults-file|-def <defaults-file> {FILE}	Fully qualified path to the properties file you want to use. Example: -defaults-file/tmp/liquibase.properties	-
-labels|-la	Label expression to use for filtering the changes to operate on.	-
-liquibase-schema-name|-lbsn	Schema to use for Liquibase objects.	-
-liquibase-tablespace-name|-lbtn	Tablespace to use for Liquibase objects.	-
-log|-lo	Enable logging. Standard logging is INFO level (no debug flag). Debug logging is FINEST level (both log and debug flag).	-
-search-path|-sep	Complete list of locations to search for files such as changelog files. You can specify multiple paths by separating them with commas.	-
-secure-parsing|-scp	If true, remove functionality from file parsers, which can be used insecurely. An example is disabling remote XML entity support.	True
-output-default-schema|-ouds	Controls whether names of objects in the default schema are fully qualified or not. If false, only objects outside the default schema are fully qualified.	False

Example

Mark changes as executed in the database up to and including tag.

cd <lb-changes-directory>
-- Edit changelog file and add tagDatabase entries for versions.
-- Execute command using a tag specified in tagDatabase in the changelog file.
SQL> lb changelog-sync-to-tag -tag version1 -changelog-file controller.xml