This project has moved and is read-only. For the latest updates, please go here.

Deploying the filter

There are two ways to use the filter, either by calling SqlPackage.exe directly or by using Publish in Visual Studio / Sql Server Data Tools.

If you use SqlPackage.exe:

You need to copy the filter to the same directory as sqlpackage.exe. You can either then share the filter with everyone who uses this folder or you can copy the DAC\bin folder to a private location and use it from there.

I use this method as it means I feel that I have more control over the generation of scripts etc and I check then bin folder and filter into TFS so when the code is run on the CI server it has everything it needs.

In the download zip, you will find a folder called "SqlPackage Deployment" - copy the files from that folder into the folder with sqlpackage.exe in.

If you use publish in SSDT

You need to copy the filter and its references to the extensions folder of the version of SSDT you are using, for me on Visual Studio 2013 with the November 2014 SSDT update, it is:

C:\Program Files (x86)\Microsoft Visual Studio 12.0\Common7\IDE\Extensions\Microsoft\SQLDB\DAC\120\Extensions

You can either extract all the dlls into that folder, or I prefer to create a sub folder and keep my files in there.

Last edited Feb 4, 2015 at 7:21 AM by AgileSqlClub_EE, version 1