Recipes for Continuous Database Integration: Evolutionary Database Development

Recipe 2Extracting Your Database in Scripts

Problem: You can't find the right version of the database to go with your application

You want to demonstrate your application to your customers and need the database version that goes with that application build. You have several database backups but don't know which database version goes with which application build.

Solution

Many projects have the database structure defined in the database, which is controlled by the database administration (DBA) group. When someone wants to demonstrate the application or have another instance of the database, re-creating the database so that the application can run against it correctly is usually difficult. You want to extract the database structure into SQL scripts ...