The MSDN page for SQLPackage is great for all the information you could possibly need to use SQLPackage via command line. And there are a lot of options, especially with the Properties: although these can be set in a publish.xml file, you can override whatever is specified within the publish file by specifyingthe property name and setting the value. This is especially useful when you don’t want to have many publish.xml files in a solution.

However one thing the MSDN page misses are examples, which is strange because the MSDN pages usually have many examples. Nevertheless it’s still a great resource, but recently I needed to deploy some dacpacs and needed to specify multiple properties via cmdline. At first I thought it could be done like so:

/p:Storage="Memory";AllowIncompatiblePlatform=True

But this turned out to be incorrect. What you actually need to do is specify “/p:” for each property you are going to call:

/p:Storage=Memory /p:AllowIncompatiblePlatform=True