hawkbit icon indicating copy to clipboard operation
hawkbit copied to clipboard

MSSQL Migration Error

Open meladon1337 opened this issue 1 year ago • 0 comments

When applying the migrations to a azure mssql Database the following migration does not work. https://github.com/eclipse/hawkbit/blob/master/hawkbit-repository/hawkbit-repository-jpa/src/main/resources/db/migration/SQL_SERVER/V1_12_16__add_action_initiated_by___SQL_SERVER.sql

Fixed the issue with the "GO;" because it does not work in one statement: ALTER TABLE sp_action ADD initiated_by VARCHAR(64) NOT NULL CONSTRAINT DF_SpAction_InitiatedBy DEFAULT ''; GO; ALTER TABLE sp_action DROP CONSTRAINT DF_SpAction_InitiatedBy; ALTER TABLE sp_target_filter_query ADD auto_assign_initiated_by VARCHAR(64);

meladon1337 avatar Feb 21 '24 12:02 meladon1337