• Steve Jones - SSC Editor (6/9/2016)


    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

    Thank you for the reply, I'm familiar with these tools but still haven't really tried them out.

    For the given constraints limitation, you can address it manually, reordering script execution:

    1 - Create the new table

    2 - Insert new reference data

    3 - Create new column on old table with a default value that exists on new table column

    4 - Create FK constraint on old table

    The issue here is that we'd like an automated process and not havr to re-order scripts manually.

    Does Redgate CI/CD tool perform this re-ordering automatically?