Andy Llewellyn (5/6/2010)
We use RedGate SQL Compare to create all the scripts for a DB and this structure is then held in Subversion.We then develop using QA (or whatever suits the developer).
When we need to commit back to the branch then the first step is to compare the script folder with the development DB and synchronise any scripts that need it. Then you commit to subversion in the normal way.
We find this works well for our needs at the moment.
Andy,
Have you had a chance to try SQL Source Control? This should save you the additional steps of having to use SQL Compare to compare your dev DB to a scripts folder and commit to SVN, as it integrates this as a single action in SQL Server Management Studio. It's in early access at the moment, so I wouldn't recommend relying on it in a production environment, but I'd really welcome any feedback on the tool and the workflow.
http://www.red-gate.com/products/SQL_Source_Control/index.htm
David Atkinson
Product Manager
Red Gate Software