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


Continuous Delivery


Continuous Delivery

Author
Message
Steve Jones
Steve Jones
SSC-Forever
SSC-Forever (41K reputation)SSC-Forever (41K reputation)SSC-Forever (41K reputation)SSC-Forever (41K reputation)SSC-Forever (41K reputation)SSC-Forever (41K reputation)SSC-Forever (41K reputation)SSC-Forever (41K reputation)

Group: Administrators
Points: 41146 Visits: 18873
Comments posted to this topic are about the item Continuous Delivery

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
Gary Varga
Gary Varga
SSChampion
SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)

Group: General Forum Members
Points: 10364 Visits: 6350
I agree that a key concept of Continuous Delivery (CD) is that CD <> Continuous Release.

Not all development deliveries are suitable releases and the criteria for a development delivery is a subset of those for a release. You should always be able to go back to any release, in fact to any delivery.

The key skills in achieving this is good management of source control. What I am referring to is primarily branching and merging. I have worked on projects where this has been achieved for the database through scripts, however, due to the complexities of databases sometimes a manual procedure has needed to be performed. In those cases documenting and storing the release process is more important than ever to achieve the requirement to be able to repeat any delivery (and, hence, all releases).

Gaz

-- Stop your grinnin' and drop your linen...they're everywhere!!!
Dalkeith
Dalkeith
SSC-Enthusiastic
SSC-Enthusiastic (195 reputation)SSC-Enthusiastic (195 reputation)SSC-Enthusiastic (195 reputation)SSC-Enthusiastic (195 reputation)SSC-Enthusiastic (195 reputation)SSC-Enthusiastic (195 reputation)SSC-Enthusiastic (195 reputation)SSC-Enthusiastic (195 reputation)

Group: General Forum Members
Points: 195 Visits: 1110
From my experience it can be difficult to do continuous delivery if there are real big changes to back ends.

For Enterprise Data Applications I have found that the key to continuous delivery for me is getting the structure of the data in your backend correct from the start (Good Normalisation adherence usually covers it for me). If you know the domain well you should be able to add in extra tables / fields in the knowledge that you might need them later. Large changes in backend almost negate continuous delivery as not only do you change the backend structure but sometimes you need to migrate the data in the backend. If that backend is being continuously updated it can be impossible to prevent loss of data without a downtime when you say to people "do not add or edit information the system between this time period".

I generally practice continuous delivery but the times I have had to do say to people the system is going to be down its because I had to make biggish changes to the backend and data had to be transferred and manipulated, downtime could not be avoided.
IceDread
IceDread
Old Hand
Old Hand (359 reputation)Old Hand (359 reputation)Old Hand (359 reputation)Old Hand (359 reputation)Old Hand (359 reputation)Old Hand (359 reputation)Old Hand (359 reputation)Old Hand (359 reputation)

Group: General Forum Members
Points: 359 Visits: 1145
Yeah, we actually have a similar own built tool that we use ourselves and have others use. That's proof of concept =)
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