Category: VSTS DB Pro
SQL Projects & Change Data Capture
Author: paschott Published Date: August 26, 2014 Leave a Comment on SQL Projects & Change Data Capture
I ran across this article from MSSQLTips.com discussing the use of CDC with SQL Projects. We don’t use CDC with our current systems so I’d…
SSDT: Setting Different Permissions per Environment
Author: paschott Published Date: May 14, 2013 10 Comments on 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…
SSDT: Trick to Not Run Pre/Post SQL on Publish
Author: paschott Published Date: May 14, 2013 2 Comments on 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…
Learning to work around DB Pro
I’ve been trying to get a multi-database solution working correctly with MS Visual Studio Team System for Database Professionals (aka DBPro or DataDude). Anyone who…