Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Version Control - Migrating Objects to Production


Version Control - Migrating Objects to Production

Author
Message
Steve Jones
Steve Jones
SSC-Dedicated
SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)

Group: Administrators
Points: 36042 Visits: 18736
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/sjones/vcspart4.asp

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Brian Lockwood
Brian Lockwood
SSC Veteran
SSC Veteran (212 reputation)SSC Veteran (212 reputation)SSC Veteran (212 reputation)SSC Veteran (212 reputation)SSC Veteran (212 reputation)SSC Veteran (212 reputation)SSC Veteran (212 reputation)SSC Veteran (212 reputation)

Group: General Forum Members
Points: 212 Visits: 2
Steve - the HTML title of this is wrong I think. it is same title as #3 so when you add them to favorites this one overwrites #3 - just a note

good series

Brian Lockwood
President
ApexSQL - SQL Developer Essentials

http://www.apexsql.com/blog

Stand up for an Independent SQL Community - be Informed
kreynolds
kreynolds
SSC-Enthusiastic
SSC-Enthusiastic (167 reputation)SSC-Enthusiastic (167 reputation)SSC-Enthusiastic (167 reputation)SSC-Enthusiastic (167 reputation)SSC-Enthusiastic (167 reputation)SSC-Enthusiastic (167 reputation)SSC-Enthusiastic (167 reputation)SSC-Enthusiastic (167 reputation)

Group: General Forum Members
Points: 167 Visits: 97

Hi Steve,

For what its worth I think your article was good.   I really like the idea of having rollback script/release, allthough for me (and Im sure most people), the headaches of trying to reliably produce it from our source code would be difficult with multiple development streams on the go, at the same time, with varying release to production schedules, hot fixes...

I think the only way to generate the rollback reliably is for the deployment tool/script/whatever, to detect/know the code being released and automaticaly generated the rollback script/release at the time of deployment.   Yeah I know..not trivial!

Sorry I cant provide some insightfull and novell approach, except that i agree with most of the points in your articles, and that automating release deployments is the way to go.   At least with an automated tool there is a standardisation and simplification of process, and the possibility of improving it by adding more featues. 

A bit of background from my place (hopefully you wont cringe), we have a simple VBS script (yeah I know boring!), but it doesnt need any configuration to be used.   Just copy the scripts and DTS packages into pre-defined folders, run it (specifiying the database and SQL server), job done, with a nice little log file and a "release history" table in each database which records all releases applied to a database, when, by whom, success/failed (damned handy!).  Its not perfect, and requires the sql scripts to be full of conditional logic,  but overall it has made a massive reduction in the number of issues related to db code deployment, which we used to do using custom scripts for each release. 

ok... think Ive been writing too much, best go...

Take it easy, good luck.

Kev





Vic Kirkpatrick-173212
Vic Kirkpatrick-173212
Mr or Mrs. 500
Mr or Mrs. 500 (501 reputation)Mr or Mrs. 500 (501 reputation)Mr or Mrs. 500 (501 reputation)Mr or Mrs. 500 (501 reputation)Mr or Mrs. 500 (501 reputation)Mr or Mrs. 500 (501 reputation)Mr or Mrs. 500 (501 reputation)Mr or Mrs. 500 (501 reputation)

Group: General Forum Members
Points: 501 Visits: 76
Having rollback scripts for text-based objects like stored procedures, triggers, views is one thing (relatively easy) However, having rollback scripts for scripts that change structure, rearrange data, etc is entirely another. In my career, we never do this ahead of time, but only if there is a problem in rolling out the original structure change, then we attempt to fix it from the state that the problem left it in and go from there.  -Vic
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search