Tag: Database Projects

Categories
SQL Server

Smarter Database Project Deployments with SQLCMD Variables

A regular Database Project deployment is static and delivers consistent results regardless of environment. When it comes to schema, that’s usually desired, but data is a different story. Data is environment specific. You want a Database Project that works across all environments. You want smarter deployments. You need SQLCMD Variables. What are SQLCMD variables SQLCMD is a […]

Categories
SQL Server

Database Projects are Amazing for Deployments

If you’ve been using Database Projects for simply maintaining copies of your database objects – like I used to – then you’ve been missing out on the power of its deployments. Initially I was sceptical about how it could effectively perform upgrades but after seeing them land in SSMS last month I wanted to revisit them as a means […]