9.12.3 changelog-sync-sql
Output the raw SQL used by Liquibase when running changelogsync.
Syntax
Liquibase|lb changelog-sync-sql|chss {OPTIONS}
Options
Option | Description | Default |
---|---|---|
Required | ||
-changelog-file|-chf |
The root changelog file. | - |
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 |
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 Debug logging is |
- |
-output-default-schema|-ouds |
Control 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 |
-output-file|-ouf |
The name of the file to write the output to. | - |
-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 |
Example
Generate SQL to mark changes as executed in the database:
-- Set default output path
SQL> cd <output-files-path>
-- Connect to target and execute command
SQL> connect <db-connect-string>
SQL> lb changelog-sync-sql -changelog-file countries_table.xml -outputfile countries_synch.sql