• Thanks for the feedback.  The approach I have outlined does provide for the change control of "system data" (or "reference data" or "meta data").  It may be just a difference in terminology as I refer to this data in my articles as "static data".

     

    I will reiterate here what has been discussed on the forum for Part 1.  I have tried to write the articles as generically as possible.  My goal is to convey the concepts of SQL object (and hence database) version control and automated generation of change scripts.  My experience of database change management over many years has proven that huge improvements in this area are long overdue.  Yes, automation of your processes requires software.  But it can be software of your choosing or you can write your own.  There are also some good articles around that discuss alternative approaches e.g. links to Steve Jones articles on Part 1 forum.

     

    Thanks,

     

    Darren Fuller

    darren.fuller@innovartis.co.uk