O'Reilly logo

Recipes for Continuous Database Integration: Evolutionary Database Development by Pramod Sadalage

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Recipe 12Naming Upgrade Scripts

Problem: What's the best strategy for naming upgrade scripts?

When a database is being changed, how do you make sure you have scripts to upgrade environments such as UAT and production? These environments can't afford to lose data. Upgrade scripts should also be tested before they are applied to other environments.

Solution

Refactoring Databases: Evolutionary Database Design discussed three strategies for identifying refactorings: BuildNumber, TimeStamp, and UniqueIdentifier. In addition, when a mature application doesn't require many database changes, you can use release-level naming. This strategy is called Release. Naming of upgrade scripts or change scripts is important when database changes depend on the previous ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required