g.britton (6/8/2016)
Just to quickly answer the final question:So, is anyone doing CI with SQL server yet?
These days, it seems everyone is doing CI with SQL Server. Redgate (sponsors of this forum) have a suite of products dedicated to just that. Just click the Redgate link at the top right of any page on this forum then click on DLM. (Disclaimer: I do not work for Redgate and we are not using DLM where I work)
Redgate are hardly alone in this space! There are plenty of other players and lots of home-grown solutions.
I'll say the Redgate solutions for CI/CD are pretty well done. Not perfect, but we handle lots of things, including data and schema changes. We handle constraints. We can manage renames, table/column splits, partitioning, data changes in migrations and more.
There are two ways of doing this. One with with SQL Source Control and the DLM Automation Suite. The other is with ReadyRoll. Both of these lend themselves to good automation and CI/CD processes.
Disclosure: I work for Redgate Software