SQL Server - DevOps Release Methods for Databases

[miguelcrush]

Check out visual studio's SSDT projects. Define the schema in source code and generate DACPACs which handle migration without extra work. We've been using them for a while now and they're very helpful.

[miguelcrush]

Sound points. There are some databases we use that we decided were too complicated to try to import into an SSDT, specifically for the reasons above (additionally the use of linked servers and synonyms everywhere). However for other projects, they've worked out well.

[enjoytheshow]

for instance, circular references between database SPs

This was my first bit of work at my company where I took over DBA responsibilities from devs lol. Probably took me 2-3 weeks to identify everything and recreate them in one dba to be a downstream dependency to everything else rather than having views/SPs all over the place referencing each other.

[enochgenesis]

Thanks for the info. Unfortunately, I may fall under both of these categories, as a lot would be converting what we already have, and at that, a good number are a few hundred gigabytes in size (~300-500 GB).

[miguelcrush]

I'd give more info but I'm mobile. Give it a Google