sqlpackage exception: Unrecognized command line argument BlockOnPossibleDataLoss

Question

I'm running the below command in my CMD:

sqlpackage /action:Publish /SourceFile:"Database Services\bin\Release\Database Services.dacpac" /TargetConnectionString:"Data Source=TEST05,123;Integrated Security=True;Persist Security Info=False;Pooling=False;MultipleActiveResultSets=False;Connect Timeout=60;Encrypt=False;TrustServerCertificate=False;Initial catalog=test" /p:BlockOnPossibleDataLoss=False

but getting this exception:

*** Unrecognized command line argument 'p:BlockOnPossibleDataLoss=False'.

What is wrong with the syntax? I followed the official documentation

Answer 1

Hi arielman2304-0180,
After some test, it seems your command runs without issue.

Could you please try to run the CMD as administrator?

Best Regards,
Amelia