| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic |
|---|---|---|---|---|---|---|---|
Project-Oriented Database Development using Command-Line Tools |
View available resources on command-line tools that SQL Server Data Tools provides for working with .dacpac files, such as SQLPackage.exe and dbSqlPackage. |
markingmyname |
maghan |
04/26/2017 |
sql |
ssdt |
conceptual |
SQL Server Data Tools proves command-line tools that enable a number of project-oriented database development scenarios.
| Topic | Description |
|---|---|
| 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 Azure SQL Database. - Publish a .dacpac to a remote/local SQL Server or Azure SQL Database to incrementally upgrade it. - Publish from a local SQL Server database to a remote SQL Server or Azure SQL Database to incrementally upgrade the remote database. - Compare a .dacpac to a remote/local SQL Server or Azure SQL 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. |