Best Database Change Control Methodologies

Posted by SnapJag on Stack Overflow See other posts from Stack Overflow or by SnapJag
Published on 2009-02-11T00:36:40Z Indexed on 2010/04/11 11:53 UTC
Read the original article Hit count: 451

As a database architect, developer, and consultant, there are many questions that can be answered. One, though I was asked recently and still can't answer good, is...

"What is one of, or some of, the best methods or techniques to keep database changes documented, organized, and yet able to roll out effectively either in a single-developer or multi-developer environment."

This may involve stored procedures and other object scripts, but especially schemas - from documentation, to the new physical update scripts, to rollout, and then full-circle. There are applications to make this happen, but require schema hooks and overhead. I would rather like to know about techniques used without a lot of extra third-party involvement.

© Stack Overflow or respective owner

Related posts about database

Related posts about schema