Software Configuration Management (SCM) systems have been available for over 20 years and have provided significant benefits to application development teams as well as the companies that supported and sponsored their implementation. The most important benefits include:
Introducing Database Change Management from dbMaestro
dbMaestro’s TeamWork is a Database Change Management solution that now brings all of the benefits of application SCM systems to databases. TeamWork allows database development to become an integral part of a disciplined SCM process instead of a manual or, at best, a semi-automated process. The benefits of SCM are significantly enhanced for organizations that treat both database development and source code development equal from an SCM perspective.
The Challenges of Database Development without TeamWork
Without TeamWork, the challenges organizations face is that there is typically a two-step process when checking-in and checking-out the database object DDL. This often leads to the wrong DDL being check-in or the wrong DDL being applied to the database. There is a work-around procedurally for this, but risks always exist to some degree with a manual process. For example, there is no validation that the right DDL is being checked-in to SCM or applied to the database. Also, the database object itself is never locked and can be changed at any time without a corresponding change in the DDL of the object that is stored in the repository. This can lead to discrepancies and loss of synchronization between the object in the database and the DDL in the repository. This change is also not logged or audited in any standard fashion, so repeatability, accountability and auditing are also hampered.