We have several triggers on our tables. One of many is like
CREATE TRIGGER yyyy ON xxx FOR INSERT, UPDATE, DELETE AS RAISERROR(''You are not allowed to modify the table xxx',13,1); ROLLBACK TRAN;
This table contains data. When the database is backed up to BACPAC via Azure management portal, it goes fine. When we try to restore such BACPAC, it throws an error because the trigger is fired when inserting data to the table.
This is wrong. We have several triggers that guards DB integrity (business logic beyond FK keys, constraints) and we need to have such triggers in DB.
The correct way is to DISABLE all triggers before inserting (bulkinsert?) data from BACPAC.
PS: few moths back everything was fine when restoring BACPAC while having triggers in DB model