Working with Azure BACPAC files from the command-line using SqlPackage.exe

If you need to work with Azure's and SQL Server's BACPAC files (as in the "Export Data-tier Application" command) from the command-line, there's a nice utility just for that: SqlPackage.exe.

The SqlPackage utility allows you to do the same import and export functions as the interactive SQL Server Management Studio (SSMS). But if you need to automate things, or have more than a couple of BACPAC files to process, a command-line tool is much more efficient.

For more information about the tool, see the MSDN documentation. If you have SQL Server installed locally, the utility resides usually in the path:

C:\Program Files (x86)\Microsoft SQL Server\130\DAC\bin\SqlPackage.exe

Hope this helps!