DB Schema changes when using Source Code

Jul 28, 2011 at 5:45 PM

If you want to use the Source Code repository to build a (test?) site, how does one know if the changes need a database schema change - new field and/or table?
Is it just a matter of reading all the comments since the last release, or is there a policy for each change to provide an incremental SQL change script?


Jul 28, 2011 at 6:49 PM

Typically, SQL Server script always up to date. If there change not yet implemented for DB provider, check-in comment usually specifically mentions it. All other supported DB scripts updated right before release.