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 […]
Last month in SSMS v22.4, we had the Database DevOps (preview) workload introduced which brings with it Database Projects. Last week I shared my favourite features for them which make deployments amazing. But if you’ve tried them out in SSMS you might have noticed that not everything is present. It’s a preview, after all. So what can we […]
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 […]
Andy Brownsword 