Last modified on 4th September 2018

DACPAC deployment using SSMS

Connect to SQL Server where you want to install SQLWATCH and right-click “Databases” and click “Deploy Data-Tier Application”

SQL Deploy SQLWATCH Data Tier Application (DACPAC)

Next, find the DACPAC you have downloaded:

SQL Deploy SQLWATCH Data Tier Application (DACPAC)

On the next page you can specify different database name – default SQLWATCH. If the database does not exist it will be created in the default location as in the server configuration. The post-deploy script loads reference data and creates SQL Agent Jobs. You can save it and review.

SQL Deploy SQLWATCH Data Tier Application (DACPAC)

Click next for a summary screen and Next one more time to execute deployment. It can take a minute or two:

SQL Deploy SQLWATCH Data Tier Application (DACPAC)