SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Database Change Management Best Practices : Achieving an Automated App


Database Change Management Best Practices : Achieving an Automated App

Author
Message
Steve Jones
Steve Jones
SSC Guru
SSC Guru (61K reputation)SSC Guru (61K reputation)SSC Guru (61K reputation)SSC Guru (61K reputation)SSC Guru (61K reputation)SSC Guru (61K reputation)SSC Guru (61K reputation)SSC Guru (61K reputation)

Group: Administrators
Points: 61839 Visits: 19099

These are articles are by the author of the whitepaper and will be coming every Wed for the next few weeks. They form the basis for a methodology that doesn't require dbGhost, but was the theory behind why it was developed.

As far as not having a budget, you're stuck. Any good VCS product will require some $$. I was in the same boat and developed my own manual/automated solution, mostly a process. You can read about it here:

http://www.sqlservercentral.com/columnists/sjones/vcspart1.asp

http://www.sqlservercentral.com/columnists/sjones/vcspart2.asp

http://www.sqlservercentral.com/columnists/sjones/vcspart3.asp

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
Peter Schott
Peter Schott
UDP Broadcaster
UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)

Group: General Forum Members
Points: 1475 Visits: 1918
Thanks, Steve. That makes me feel a little better. The first part was a direct quote from the white paper and that didn't bode well for the rest of the series. :-) I'll take a look at your columms, too. The whole process is interesting - it's just a hard sell to buy new products for development.

I will be interested in the whole methodology behind this to see what they did and thought of. The product concept looks like it could be useful, it's just tough to sell that sort of solution for our environment.

-Pete Schott
Steve Jones
Steve Jones
SSC Guru
SSC Guru (61K reputation)SSC Guru (61K reputation)SSC Guru (61K reputation)SSC Guru (61K reputation)SSC Guru (61K reputation)SSC Guru (61K reputation)SSC Guru (61K reputation)SSC Guru (61K reputation)

Group: Administrators
Points: 61839 Visits: 19099
It is, especially when you have to license all developers. I've not successfully licensed any product for everyone.

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
Darren Fuller
Darren Fuller
SSC Rookie
SSC Rookie (49 reputation)SSC Rookie (49 reputation)SSC Rookie (49 reputation)SSC Rookie (49 reputation)SSC Rookie (49 reputation)SSC Rookie (49 reputation)SSC Rookie (49 reputation)SSC Rookie (49 reputation)

Group: General Forum Members
Points: 49 Visits: 1

Many thanks for the feedback. I have tried to write the articles (white paper) as generically as possible. I really want to convey the concepts of SQL object (and hence database) version control and automated generation of change scripts. After many years as a DBA, I haven't seen things improve much in this area. The ideas and process outlined is working successfully in production environments. Yes, the concept requires some software for automation and it can be software of your choosing. I have tried to address some of the considerations for implementing an automated approach. If that is not an option, there are some good articles around - thanks Steve.

Thanks,

Darren Fuller

darren.fuller@innovartis.co.uk


Ken McNeil
Ken McNeil
Forum Newbie
Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)

Group: General Forum Members
Points: 4 Visits: 1

The only reason I came across the whitepaper was because I could not wait for the ending, Darren was speaking on a topic that I am in the middle of, and I need an answer before the next article was released. If this piece of software does what it says it can do, I have no problem paying for it. We have currently brought in 4 consultants to fix a f$#%^ed Database that would have been in better shape if we would have had some form of change control, (and a good SQL DBA, but that's another story). For the price of this software, if it does what it says it does, part of my problems will be solved. I've had heard pitches for software before but this one is right on the money. I am in the process of setting up a lab to test the software, to see if it does what it say's. If it does, thank you Darren.

p.s. Sorry if I took the wind out of your sails mate!!


Peter Schott
Peter Schott
UDP Broadcaster
UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)

Group: General Forum Members
Points: 1475 Visits: 1918
I appreciated the info, Ken. My first reaction was thinking that this was going to turn into a multi-part post that just quoted the white paper. Hearing from others, it appears that isn't the case and I'm glad to hear it. I agree that this software sounds really promising - it's just that I have trouble justifying major expense being that we're not a software shop. We have a pretty small team and changes are mostly manageable now. I'm just always looking for something better than source safe and database compares. I'll be interested to read the rest of the articles to see the ideas behind this.

-Pete
jwrichy
jwrichy
SSC Rookie
SSC Rookie (26 reputation)SSC Rookie (26 reputation)SSC Rookie (26 reputation)SSC Rookie (26 reputation)SSC Rookie (26 reputation)SSC Rookie (26 reputation)SSC Rookie (26 reputation)SSC Rookie (26 reputation)

Group: General Forum Members
Points: 26 Visits: 11
I'd love to here the results of your testing Ken, I'm going to be doing the same thing but it sounds like you might get there first.



centexbi
centexbi
Grasshopper
Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)

Group: General Forum Members
Points: 21 Visits: 38

We use

  • Perforce for version control
  • PowerDesigner for table creation and maintenance. Both the PowerDesigner file and the generated SQL file (create statements) are checked in Perforce
  • RedGate SQL Compare to detect the changes and then build a a script to update each database.

We can get 60-80% of the changes generated by SQL Compare. The rest is hand crafted as we use the scripts in an upgrade of our product. The integration of the generated scripts with the manually written scripts is sequenced in a batch command file.

Hope this helps others who are thinking about version control and upgrades.


sdelmore
sdelmore
Grasshopper
Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)

Group: General Forum Members
Points: 14 Visits: 397
Oops, nevermind, I made a comment not realizing the concern had allready been voiced in another post.



Shane
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