How To: Remove a Change Set that has incorrect SQL

Overview

If a change set fails when you attempt to deploy it because of an error in the SQL, you may want to remove that change set from your changelog. Removing the change set will avoid deploying or attempting to deploy that change set during future deployments.

Instructions

1. Open your project in the Liquibase Business desktop client:

   Open

   

    

2. Get the latest version of the project from SCM (source control). For example., "git pull".

3. Click on the “Design” tab:

   Open

   

    

4. On the Design tab, locate the specific change set that you want to remove and highlight it:

    

5. Right-click and choose “Remove”:

    

6. Now you can see that change set was removed from the changelog:

    

7. When you are done removing change sets, save your modified changelog. Go up to the “File” menu in the top left and select “Save”:

    

8. After saving your changes, click on the “Plan” tab to return to the main view of your project:

    

9. Commit and push your project back to SCM (source control) because your changelog.xml file has been modified. For example, "git commit ..." followed by "git push".

You are finished! Removing the change set from your changelog prevents it from being deployed or attempting to be deployed to any of your Liquibase Business environments.