Maven updateSQL

Uses

The Maven updateSQL goal is typically used when you want to inspect the raw SQL before running the update goal, so you can correct any issues that may arise before running the goal. Liquibase uses the raw SQL to apply changes that you have added to the changelog file to the database.

Maven configuration

You can configure Liquibase Maven in multiple ways. You can pass arguments like <changeLogFile> in Maven directly in your pom.xml file, in a liquibase.properties file referenced in your POM, as environment variables, or as JVM system properties. To learn about each file's syntax, see Maven Properties.

For more information about the Maven configuration, see Configuring Maven.

Running the updateSQL Maven goal

Running the updateSQL goal requires a Maven project to be implemented. To run the goal, type the following in your command prompt:

mvn liquibase:updateSQL

Note: You can also add the liquibase.migrationSqlOutputFile attribute and specify the file to output the migration SQL script to. The default file is migrate.sql. If it exists, it will be overwritten.

Maven updateSQL output

Starting Liquibase at 12:56:38 (version [local build] #0 built at 2024-02-01 19:20+0000) [INFO] Set default schema name to PUBLIC [INFO] Output SQL Migration File: C:\Users\project-path-here\target\liquibase\migrate.sql [INFO] Parsing Liquibase Properties File liquibase.properties for changeLog parameters [INFO] Executing on Database: jdbc:h2:tcp://localhost:9090/mem:dev; [INFO] Successfully acquired change log lock [INFO] Creating database history table with name: DATABASECHANGELOG [INFO] Using deploymentId: 7321400093 [INFO] Table person created [INFO] ChangeSet db/changelog/db.changelog-master.xml::1::your.name ran successfully in 10ms [INFO] Table company created [INFO] ChangeSet db/changelog/db.changelog-master.xml::2::your.name ran successfully in 7ms [INFO] Columns country(varchar(2)) added to person [INFO] ChangeSet db/changelog/db.changelog-master.xml::3::other.dev ran successfully in 7ms [INFO] Update command completed successfully. [INFO] Successfully released change log lock [INFO] Command execution complete [INFO] ------------------------------------------------------------------------ [INFO] [INFO] ------------------------------------------------------------------------ [INFO] BUILD SUCCESS [INFO] ------------------------------------------------------------------------ [INFO] Total time: 3.212 s [INFO] Finished at: 2024-02-07T12:56:40-03:00 [INFO] ------------------------------------------------------------------------

Example of the output file

-- ********************************************************************* -- Update Database Script -- ********************************************************************* -- Change Log: dbchangelog.xml -- Ran at: 11/27/20 3:39 AM -- Against: MVN_UAT@jdbc:oracle:thin:@localhost:1521/ORCL -- Liquibase version: 4.1.1 -- ********************************************************************* -- Lock Database UPDATE DATABASECHANGELOGLOCK SET LOCKED = 1, LOCKEDBY = 'WIN-20E107KB4TN (172.30.3.88)', LOCKGRANTED = TO_TIMESTAMP('2020-11-27 03:39:22.226', 'YYYY-MM-DD HH24:MI:SS.FF') WHERE ID = 1 AND LOCKED = 0; --changeset dbchangelog.xml::1606322157619-5::Nataliya (generated) CREATE TABLE 25 (COLUMN14 VARCHAR2(20 BYTE)) TABLESPACE USERS; INSERT INTO DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('1606322157619-5', 'Nataliya (generated)', 'dbchangelog.xml', SYSTIMESTAMP, 5, '8:af84f39a12a1f82c4ae37687c38e95c3', 'createTable tableName=25', '', 'EXECUTED', NULL, NULL, '4.1.1', '6469962817'); --changeset dbchangelog.xml::1606322157619-16::Nataliya (generated) CREATE TABLE 34 (COLUMN1234 VARCHAR2(20 BYTE)) TABLESPACE USERS; INSERT INTO DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('1606322157619-16', 'Nataliya (generated)', 'dbchangelog.xml', SYSTIMESTAMP, 6, '8:5503ac52c79f588a025ae7e63123aa31', 'createTable tableName=34', '', 'EXECUTED', NULL, NULL, '4.1.1', '6469962817'); --changeset dbchangelog.xml::1606322157619-17::Nataliya (generated) CREATE TABLE 24 (COLUMN134 VARCHAR2(20 BYTE)) TABLESPACE USERS; INSERT INTO DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('1606322157619-17', 'Nataliya (generated)', 'dbchangelog.xml', SYSTIMESTAMP, 7, '8:f2e0f707ef1a00342c91438c3bfccc16', 'createTable tableName=24', '', 'EXECUTED', NULL, NULL, '4.1.1', '6469962817'); -- Release Database Lock UPDATE DATABASECHANGELOGLOCK SET LOCKED = 0, LOCKEDBY = NULL, LOCKGRANTED = NULL WHERE ID = 1;