Project-Oriented Database Development using Command-Line Tools

  • Article

 

SQL Server Data Tools proves command-line tools that enable a number of project-oriented database development scenarios.

In This Section

SqlPackage.exe

This topic describes the SQLPackage.exe utility, used for the following tasks:

  • Extract a .dacpac file from a live SQL Server database.

  • Publish a .dacpac file to a live SQL Server database to incrementally update the live database schema to match the .dacpac.

  • Compare a .dacpac file to a live SQL Server database and generate an incremental upgrade Transact-SQL script without updating the live database.

  • Compare two .dacpac files to generate an incremental upgrade Transact-SQL script.

  • Generate an XML report that summarizes the incremental upgrade changes that would occur if the database was incrementally upgraded.

Using MSDeploy with dbSqlPackage Provider

This topic describes the Web Deployment Tool provider named dbSqlPackage included with SSDT, which works with the Microsoft Internet Information Services (IIS) Web Deployment Tool (MSDeploy.exe), used for the following tasks:

  • Extract a .dacpac file from a remote/local SQL Server or SQL Azure database.

  • Publish a .dacpac to a remote/local SQL Server or SQL Azure database to incrementally upgrade it.

  • Publish from a local SQL Server database to a remote SQL Server or SQL Azure database to incrementally upgrade the remote database.

  • Compare a .dacpac to a remote/local SQL Server or SQL Azure database to generate an incremental upgrade Transact-SQL script without updating the live database.

  • Generate an XML report that summarizes the incremental upgrade changes that would occur if the database was incrementally upgraded.

Project-Oriented Offline Database Development