- development schema. If you have a release line for your code, your database should evolve in a similar manner.
Adopting this approach requires a change in mindset from databases as "controlled by the DBA" with changes made to the database, to the database as an active part of the development process.
Databases present their own special issues. Code can often be thought of as flat files. Databases can't.
Rather than doing nothing because you don't have the best solution, consider adapting basic SCM practices. We'd like to hear what your thoughts are about this issue. Email us, or discuss this in the General CM forum on CM Crossroads.