Context I'm making an SSDT project for a database design which gets deployed to a number of environments, which each end in their environment name (eg. AFrameworkDEV1, AFrameworkDEV2, BFrameworkDEV1, ...
I'm struggling a bit how I should do proper error handling in SSDT, particularly in a pre deployment script. I noticed that for what ever reasons the SQLCMD syntax :on error exit is not working. ...