tag:blogger.com,1999:blog-29598966.post7278550130973064520..comments2009-07-14T13:18:47.999ZComments on Andrew Rivers: SQL Deployment StrategiesAndrewhttp://www.blogger.com/profile/01319737766041565387noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-29598966.post-51554577491844059412009-07-14T13:18:47.999Z2009-07-14T13:18:47.999ZAt the company I work for I have implemented an up...At the company I work for I have implemented an update framework that uses a mixture of the methods that you have mentioned. We have a delta script that 'upgrades' the database and its data from a version to another in the way that you have mentioned.<br /><br />We also use re-runnable scripts when it comes to the stored procs, functions, etc.<br /><br />We have found this to be very effective in a deployment environment.Richard Hooperhttp://www.blogger.com/profile/06451370312193069532noreply@blogger.com