DacFx icon indicating copy to clipboard operation
DacFx copied to clipboard

ENABLE_BROKER was disabled by publish dacpac

Open ch0mik opened this issue 2 years ago • 1 comments

I have on DB set ENABLE_BROKER = true when i publish the DacPac, the DB has set ENABLE_BROKER to false

How to set via DacPac (DacFX) the DB option ENABLE_BROKER to True ?

my project based on Microsoft.Build.Sql 0.1.12-preview and Azure DataStudio 1.45.1

Regards Pawel

ch0mik avatar Sep 15 '23 08:09 ch0mik

i put on the PostInstall Script on EOF the

use [master]
alter database [myDB] set single_user with rollback immediate
ALTER DATABASE [myDB] SET  ENABLE_BROKER WITH NO_WAIT
alter database [myDB] set multi_user with rollback immediate

and works

ch0mik avatar Sep 15 '23 09:09 ch0mik