radoslavgatev / ssdt-continuous-deployment-project-template

A project template aiming for easy Continuous Deployment of SSDT projects.

SSDT Project for Continuous Deployment

This is a template based on the default SQL Server Data Tools Project. It enables your database project to be easily deployed across different versions and environments by adding an infrastructure to implement and track Pre-Deployment scripts, Static tables and Post-Deployment scripts.

More info: www.gatevnotes.com

Install from Visual Studio Marketplace

https://marketplace.visualstudio.com/items?itemName=SolvSoftware.SSDT-Continuous-Deployment-Project-Template

Contributing to the project

Feedback with improvements and pull requests from the community will be highly appreciated and accepted.

ssdt-continuous-deployment-project-template's Issues

Unable to install VS2019

When attempting to install the extension in VS2019, I am seeing the following error:

The extension with ID 'SSDT_CD_Project.625944c8-c903-44d8-82ae-888398c19a53' is not installed to Microsoft Visual Studio Enterprise 2019.
Extension cannot be installed to the following products due to missing prerequisites:
Microsoft Visual Studio Enterprise 2019
-------------------------------------------------------
Identifier : Microsoft.VisualStudio.Component.SQL.CMDUtils
Name : SQL Server 2012 Command Line Utilities
Version : [15.0.25824.0,17.0)
Error : The prerequisite specified does not exist

I was able to install the extension without issue in VS2017 on the same machine.

Support for VS 2022?

Hello,

Is this still an active project? I notice that it will install on VS 2017 & 2019. Will it support VS 2022?

Also, I'm new to the use of MERGE queries. I see you reference the work of Daniel Nolan. I notice that he has a repo here for an "sp_generate_merge" script: https://github.com/readyroll/generate-sql-merge.

A question I have is whose work is most up to date, especially for use in Azure DB. Daniel's has more recent updates. Would his be more safe to use, cover more possible errors, etc.?

Thanks!