# Install with SSMS

## Introduction

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

{% embed url="https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms" %}

## 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](https://github.com/marcingminski/sqlwatch/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](https://1712419846-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LamHUpIpVXoBUUDZZpO%2F-LaopAo0k0BCPGbq6m39%2F-LaopzxaY_V8eEwmAjAj%2Fdeploy_datatier_application.png?alt=media\&token=d40b2645-d850-46a3-a3bf-2a6eff4e2f98)

Find the SQLWATCH.dacpac you have downloaded and unzipped

![DacPac deploy set source package path](https://1712419846-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LamHUpIpVXoBUUDZZpO%2F-LaopAo0k0BCPGbq6m39%2F-LaorCvY8bIZSU2h30g_%2Fdeploy_datatier_application_find_file.png?alt=media\&token=36968325-0346-4084-afe2-2d2c27331663)

Specify database name, default and recommended is SQLWATCH:

![DacPac deploy set target database name](https://1712419846-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LamHUpIpVXoBUUDZZpO%2F-LaopAo0k0BCPGbq6m39%2F-LaorNxyR6F1-zb2Ga2G%2Fdeploy_datatier_application_set_name.png?alt=media\&token=bece297a-d3f2-4026-9c7a-ff92446d0504)

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](https://1712419846-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LamHUpIpVXoBUUDZZpO%2F-LaopAo0k0BCPGbq6m39%2F-LaoriiWiZlUmq4uumS4%2Fdeploy_datatier_application_deploy.png?alt=media\&token=fc89a40a-95e4-4e9a-bd1a-a310f538ffdc)
