Install with SqlPackage

Introduction

SqlPackage.exe is a command line utility that automates SQL Server database deployments. This command comes with SQL Server Management Studio (SSMS) and is located in the ...\DAC\bin folder:

C:\Program Files (x86)\Microsoft SQL Server\140\DAC\bin\SqlPackage.exe

140 is the version of installed Management Studio. Your version and path may be different to the example above.

SqlPackage.exe - SQL Serverdocsmsft

Prerequisites

1. SqlPackage.exe must be installed on the computer running installation.

Installation

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

An example command to install SQLWATCH:

SqlPackage.exe 
    /Action:Publish 
    /SourceFile:C:\Temp\SQLWATCH.dacpac 
    /TargetDatabaseName:SQLWATCH 
    /TargetServerName:YOURSQLSERVER 
    /p:RegisterDataTierApplication=True