Posted in SQL Project SQL Server SSDT VSTS DB Pro

SSDT: Setting Different Permissions per Environment

One of the areas that SSDT doesn’t address adequately is permissions. Many users have different users, logins, and permissions set up across their environments, but…

Continue Reading... SSDT: Setting Different Permissions per Environment
Posted in SQL Project SQL Server SSDT VSTS DB Pro

SSDT: Trick to Not Run Pre/Post SQL on Publish

We’ve run across the need to avoid running certain scripts when publishing a brand new copy of a database from a SQL or DB Project…

Continue Reading... SSDT: Trick to Not Run Pre/Post SQL on Publish