What's a good way to package migration scripts?

swinghouseswinghouse Posts: 120 Bronze 2
edited January 15, 2013 5:26AM in Deployment Manager
Deploying changes in database objects and static table data (as defined in SQL Source Control) works beautifully with Deployment Manager + SQL Source Control + SQL Compare!

However, something I'm a bit uncertain of - and that is a big pain in the *** in my old, manual deployment routine - is how to deal with migration scripts, e.g. INSERT/UPDATE/DELETE scripts which will, e.g., change certain field values or delete certain records.

Do you have any recommendations as to how one could incorporate these scripts in the deployment process? Perhaps there is a white paper that I simply have failed to notice?

Comments

Sign In or Register to comment.