Hi,
I'm running the below sqlpackage command against my sqlserver:
sqlpackage /action:Publish /SourceFile:"Database Services\bin\Release\Database Services.dacpac" /TargetConnectionString:"Data Source=${Env};Integrated Security=True;Persist Security Info=False;Pooling=False;MultipleActiveResultSets=False;Connect Timeout=60;Encrypt=False;TrustServerCertificate=False;Initial catalog=${Target}"
It contains one predeploy script with one alter.
However, I see in the error it tries to alter the whole DB (one level up) instead just doing the alter. any idea why? does it related to some flags I need to add?
https://docs.microsoft.com/en-us/sql/tools/sqlpackage/sqlpackage-publish?view=sql-server-ver15#properties-specific-to-the-publish-action