`diff-changelog`

The diff-changelog command displays the differences between two databases you are comparing. It also generates a changelog file containing deployable changesets to resolve most of these differences.

Uses

The diff-changelog command is typically used when you want to create a deployable changelog to synchronize multiple databases. The diff-changelog command also provides more information about:

Missing objects in your database
Changes made to your database
Unexpected items in your database

Running the `diff-changelog` command

Running the diff-changelog command requires two URLs:

referenceURL – the source for the comparison. The referenceUrl attribute represents your source (reference) database, which is the basis for the database you want to compare.
url – the target of the comparison. The url attribute represents your target database, which you want to compare to the source (reference) database. You typically perform actions and run commands on this database.

To create a diff changelog:

Option 1: Run the diff-changelog command with all necessary attributes in the CLI:

liquibase diff-changelog --changelog-file=example-changelog.xml 
--url="jdbc:oracle:thin:@<IP OR HOSTNAME>:<PORT>:<SERVICE NAME OR SID>"
--username=<USERNAME>
--password=<PASSWORD>
--referenceUrl="jdbc:oracle:thin:@<IP OR HOSTNAME>:<PORT>:<SERVICE NAME OR SID>"
--referenceUsername=<USERNAME>
--referencePassword=<PASSWORD>

Tip: For best results, specify all commands and parameters in the --kebab-case format in the CLI. If your preference is camelCase, it also works in the CLI.

See the snapshot command topic for an example of using a snapshot file as one of the databases being used in the command.

Tip: Liquibase recommends that you place your database's JDBC driver JAR file in the liquibase/lib directory. If you place the driver file in a different directory, specify the path in the properties file: classpath:../<path-to-drivers>/ojdbc<version>.jar. For more information, see Create and Configure a liquibase.properties File. When you run the diff command against two databases, either the drivers for both must be in the liquibase/lib directory or the classpath property must reference both JAR files. Use the appropriate path separator for your operating system: for Windows, use a semicolon; for Mac or Linux, use a colon.

Example: classpath: ojdbc7.jar:postgresql-42.2.8.jar

Option 2: Configure the Liquibase properties file to include the connection information for both databases. Then, run the following command in the CLI:

liquibase diff-changelog --changelog-file=example-changelog.xml

Note: If you specify a changelog file name that already exists, Liquibase will append your changes to the existing file.

For information, see Create and Configure a liquibase.properties File.

Output

The diff-changelog command produces a list of all objects and creates a changelog with a list of changesets.

Liquibase Open Source diff-changelog categories:

Catalog
Column
Foreign Key
Index
Primary Key
Schema
Sequence
Unique Constraints
View

Console output example

Liquibase Version: 4.9.1						
BEST PRACTICE: The changelog generated by diffChangeLog/generateChangeLog should be inspected for correctness and completeness before being deployed. Some database objects and their dependencies cannot be represented automatically, and they may need to be manually updated before being deployed.
Liquibase command 'diff-changelog' was executed successfully.

Filtering `diff-changelog` types

You can filter what objects diff-changelog generates with the diffTypes attribute:

--diffTypes=<catalogs,tables,functions,views,columns,indexes,foreignkeys,primarykeys,uniqueconstraints,storedprocedures,triggers,sequences,databasepackage,databasepackagebody>

You can also filter specific objects by name with the includeObjects and excludeObjects attributes. For example:

--includeObjects=table:tableName,column:columnName,view:viewName,index:indexName
--excludeObjects=table:tableName,column:columnName,view:viewName,index:indexName

This way, you can prevent any undesired objects from ending up in the resulting changelog.

Additional Functionality with Liquibase Pro

While Liquibase Open Source stores all changesets in a changelog, Liquibase Pro creates a directory called Objects and places the directory at the same level as your changelog. The Objects directory contains a subdirectory for each of the following stored logic types:

checkconstraint
package
packagebody
procedure
function
trigger
synonyms

Note: Not all database platforms support all stored logic types that are listed.

The diff-changelog command structures stored logic files into timestamped directories every time you run the command.

Liquibase Pro diff-changelog example file

<?xml version="1.0" encoding="UTF-8"?>
<databaseChangeLog
    xmlns="http://www.liquibase.org/xml/ns/dbchangelog"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xmlns:ext="http://www.liquibase.org/xml/ns/dbchangelog-ext"
    xmlns:pro="http://www.liquibase.org/xml/ns/pro"
    xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog
        http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-latest.xsd
        http://www.liquibase.org/xml/ns/dbchangelog-ext http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-ext.xsd
        http://www.liquibase.org/xml/ns/pro http://www.liquibase.org/xml/ns/pro/liquibase-pro-latest.xsd">

	<changeSet  author="Administrator (generated)"  id="1571345362466-8">
		<pro:createTrigger  disabled="false"  path="objects/trigger/TS_T_EXEMPLAR_SEQEXEMPLAR.sql"  relativeToChangelogFile="true"  tableName="T_EXEMPLAR"  triggerName="TS_T_EXEMPLAR_SEQEXEMPLAR"/>
	</changeSet>
	<changeSet  author="Administrator (generated)"  id="1571345362466-9">
		<pro:createTrigger  disabled="false"  path="objects/trigger/ORDERS_BEFORE_INSERT4.sql"  relativeToChangelogFile="true"  tableName="orders"  triggerName="ORDERS_BEFORE_INSERT4"/>
	</changeSet>
	<changeSet  author="Administrator (generated)"  id="1571345362466-10">
		<pro:createTrigger  disabled="false"  path="objects/trigger/ORDERS_BEFORE_INSERT2.sql"  relativeToChangelogFile="true"  tableName="orders"  triggerName="ORDERS_BEFORE_INSERT2"/>
	</changeSet>
	<changeSet  author="Administrator (generated)"  id="1571345362466-11">
		<pro:createTrigger  disabled="false"  path="objects/trigger/ORDERS_BEFORE_INSERT.sql"  relativeToChangelogFile="true"  tableName="orders"  triggerName="ORDERS_BEFORE_INSERT"/>
	</changeSet>
	<changeSet  author="Administrator (generated)"  id="1571345362466-12">
		<createView  fullDefinition="true"  path="objects/view/OREDERS_VIEW.sql"  relativeToChangelogFile="true"  viewName="OREDERS_VIEW"/>
	</changeSet>
	<changeSet  author="Administrator (generated)"  id="1571345362466-13">
		<pro:createTrigger  disabled="false"  path="objects/trigger/ORDERS_BEFORE_INSERT3.sql"  relativeToChangelogFile="true"  tableName="orders"  triggerName="ORDERS_BEFORE_INSERT3"/>
	</changeSet>
	<changeSet  author="Administrator (generated)"  id="1571345362466-14">
		<createProcedure  path="objects/storedprocedure/P_CUSTOMER_HAS_NUM_FILM.sql"  procedureName="P_CUSTOMER_HAS_NUM_FILM"  relativeToChangelogFile="true"/>
	</changeSet>
	<changeSet  author="Administrator (generated)"  id="1571345362466-15">
		<createView  fullDefinition="true"  path="objects/view/V_CUSTOMER_HAS_FILM.sql"  relativeToChangelogFile="true"  viewName="V_CUSTOMER_HAS_FILM"/>
	</changeSet>
	<changeSet  author="Administrator (generated)"  id="1571345362466-16">
		<createProcedure  path="objects/storedprocedure/SP_CUSTOMER_SOCIAL_ACCTS.sql"  procedureName="SP_CUSTOMER_SOCIAL_ACCTS"  relativeToChangelogFile="true"/>
	</changeSet>
	<changeSet  author="Administrator (generated)"  id="1571345362466-17">
		<pro:createTrigger  disabled="false"  path="objects/trigger/TRI_BORROWING.sql"  relativeToChangelogFile="true"  tableName="T_BORROWING"  triggerName="TRI_BORROWING"/>
	</changeSet>
	<changeSet  author="Administrator (generated)"  id="1571345362466-18">
		<pro:createTrigger  disabled="false"  path="objects/trigger/TRU_BORROWING.sql"  relativeToChangelogFile="true"  tableName="T_BORROWING"  triggerName="TRU_BORROWING"/>
	</changeSet>
	<changeSet  author="Administrator (generated)"  id="1571345362466-19">
		<pro:createTrigger  disabled="false"  path="objects/trigger/TSU_T_EXEMPLAR_SEQEXEMPLAR.sql"  relativeToChangelogFile="true"  tableName="T_EXEMPLAR"  triggerName="TSU_T_EXEMPLAR_SEQEXEMPLAR"/>
	</changeSet>
	<changeSet  author="Administrator (generated)"  id="1571345362466-20">
		<pro:createFunction  functionName="F_CUSTOMER_HAS_NUM_FILM"  path="objects/function/F_CUSTOMER_HAS_NUM_FILM.sql"  relativeToChangelogFile="true"/>
	</changeSet>
</databaseChangeLog>

Note: Liquibase does not currently check data type length.

Command arguments

Attribute	Definition	Requirement
`--changelog-file`	The root changelog	Required
`--reference-url`	The JDBC reference database connection URL	Required
`--url`	The JDBC database connection URL. See Using JDBC URL in Liquibase.	Required
`--author`	Specifies the author for changesets in the generated changelog.	Optional
`--default-catalog-name`	Name of the default catalog to use for the database connection	Optional
`--default-schema-name`	Name of the default schema to use for the database connection	Optional
`--diff-types`	Specifies the types of objects to compare. Includes a list of diff types in a changelog file expressed as a comma-separated list (without spaces): `catalogs, tables, functions, views, columns, indexes, foreignkeys, primarykeys, uniqueconstraints, data, storedprocedures, triggers, sequences, databasepackage, databasepackagebody`. If null, default types are `tables, views, columns, indexes, foreignkeys, primarykeys, uniqueconstraints`.	Optional
`--driver`	The JDBC driver class	Optional
`--driver-properties-file`	The JDBC driver properties file	Optional
`--exclude-objects`	Objects to exclude from diff	Optional
`--include-catalog`	If `true`, the catalog will be included in generated changesets. Default: `false`	Optional
`--include-objects`	Objects to include in diff	Optional
`--include-schema`	If `true`, the schema will be included in generated changesets. Default: `false`	Optional
`--include-tablespace`	Include the tablespace attribute in the changelog. Default: `false`	Optional
`--output-schemas`	Output schemas names. This is a CSV list.	Optional
`--password`	Password to connect to the target database	Optional
`--reference-default-catalog-name`	The reference default catalog name to use for the database connection	Optional
`--reference-default-schema-name`	The reference default schema name to use for the database connection	Optional
`--reference-driver`	The JDBC driver class for the reference database	Optional
`--reference-driver-properties-file`	The JDBC driver properties file for the reference database	Optional
`--reference-password`	The reference database password	Optional
`--reference-schemas`	Schemas names on reference database to use in diff. This is a CSV list.	Optional
`--reference-username`	The reference database username	Optional
`--schemas`	Schemas to include in diff	Optional
`--username`	Username to connect to the target database	Optional

diff-changelog

Uses

Running the diff-changelog command

Output

Filtering diff-changelog types

Additional Functionality with Liquibase Pro

Command arguments

`diff-changelog`

Running the `diff-changelog` command

Filtering `diff-changelog` types