This article covers the seventh part of a nine-part series on Software Configuration Management (CM), focusing specifically on database upgrades. The video, produced by PowerBasic for Beginners, addresses the challenges of upgrading SQL databases without losing user data, drawing on over 20 years of CM experience.
The key distinction is made between the database schema—the structural blueprint—and the actual stored data. Effective CM ensures that schema changes are applied without compromising data integrity. The shift from manual upgrade processes to automated ones is highlighted, along with critical pre-deployment safeguards such as backups and hash comparisons.
The role of the Database Administrator (DBA) is emphasized as essential for maintaining security and performance during deployment cycles. The series includes parts on requirements, planning, development and version management, build management, testing, and more.
Watch the full video here: Software Configuration Management part 7 - appendix 1 - Database Upgrades
Related videos in the series: