Install with SSMS

Introduction

SQL Server Management Studio (SSMS) is a free, integrated development environment (IDE) for SQL Server.

Prerequisites

  1. SQL Server Management Studio that supports DacPac deployment must be installed prior to installation. This can either be on a client PC or server.

Installation

Download the required release from our GitHub Releases and unzip. In this example we are using C:\Temp

Connect to the desired SQL Server, right click on Databases and select Deploy Data-Tier Application:

SSMS Deploy Data-tier Application

Find the SQLWATCH.dacpac you have downloaded and unzipped

DacPac deploy set source package path

Specify database name, default and recommended is SQLWATCH:

DacPac deploy set target database name

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

DacPac deploy summary screen

Last updated

Was this helpful?