how to execute only specific changesets in liquibase which are unread?

Question

I have added some new changesets in an existing changelog file and want to execute only 2 among the new inserted ones. When I give the update command in liquibase it updates all the unread changesets and updates the database. But I want to execute only 2 among these newly inserted changesets in the changelog file. Is there any way of doing this in liquibase? If yes how is it possible?

SteveDonie SteveDonie · Accepted Answer · 2015-09-08T13:50:00

One way you could do this is to mark the relevant changesets with a label, and then use that label in your liquibase update command.

This blog post on labels describes their use.

Here is an example that matches what you described in your comment below.

changelog

<?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" 
  xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog
                      http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.5.xsd">

    <changeSet id="1" author="steve" labels="labelOne">
        <createTable tableName="tableOne">
            <column name="id" type="int" autoIncrement="true">
                <constraints primaryKey="true" nullable="false" />
            </column>
        </createTable>
    </changeSet>

    <changeSet id="2" author="steve" labels="labelTwo">
        <comment>Creating table "tableTwo"</comment>
        <createTable tableName="tableTwo">
            <column name="id" type="int" autoIncrement="true">
                <constraints primaryKey="true" nullable="false" />
            </column>
        </createTable>
    </changeSet>

    <changeSet id="3" author="steve" labels="labelThree">
        <comment>Creating table "tableThree"</comment>
        <createTable tableName="tableThree">
            <column name="id" type="int" autoIncrement="true">
                <constraints primaryKey="true" nullable="false" />
            </column>
        </createTable>
    </changeSet>

</databaseChangeLog>

command execution

If you wanted to update and only create table one, you would use this command (if you are using the command line, and assuming that you have a liquibase.properties file that specifies all the connection information, etc.)

liquibase --changeLogFile=changelog.xml --labels=labelOne update

If you wanted to apply two changesets, you would use a command like this:

liquibase --changeLogFile=changelog.xml --labels="labelOne and labelTwo" update

how to execute only specific changesets in liquibase which are unread?

1 Answers