Hi everybody,
I would like to get helping hand to understand why Liquibase is not letting me to deploy changesets to my MS SQL Database.
Liquibase version 4.30.0
I’m implementing Liquibase Community to already live database project. I would like to manage my database using “Liquibase formatted sql” changesets with per object strategy. I have already prepared changelog files which contains changesets of my database schema but I run into issue where adding another changeset to file is causing md5sum to change.
In theory running clear-checksum is fixing it but only until I add another new changeset to the file.
This is example of my changeset:
–liquibase formatted sql
–changeset JohnDoe:JIRA112312_New_Table
–comment: Initial table
CREATE TABLE [dbo].[actions_history](
[id] [bigint] IDENTITY(1,1) NOT NULL,
[indicator_id] [bigint] NOT NULL,
[action_id] [tinyint] NOT NULL,
[user_id] varchar NULL,
[action_date] [datetime] NOT NULL,
–liquibase formatted sql
–changeset JohnDoe:JIRA111230_Add_Column
–comment: New column.
ALTER TABLE [dbo].[actions_history]
ADD [action_status] varchar NULL;