The Author Online Book Forums are Moving

The Author Online Book Forums will soon redirect to Manning's liveBook and liveVideo. All book forum content will migrate to liveBook's discussion forum and all video forum content will migrate to liveVideo. Log in to liveBook or liveVideo with your Manning credentials to join the discussion!

Thank you for your engagement in the AoF over the years! We look forward to offering you a more enhanced forum experience.

craig.berntson (25) [Avatar] Offline
#1
Do you have your database maintenance under source control? How about part of your CI process? What tools are you using? Data Dude? RoundhousE? Something else?
mpaladino (3) [Avatar] Offline
#2
Re: Are you doing CI on your database?
We currently don't have our databases under source control, but we are moving towards getting them under source control and integrated into the CI process.
samkenny (2) [Avatar] Offline
#3
Re: Are you doing CI on your database?
Yes-ish.

I used CI for our database at a previous company and am revisiting the process. The previous firm had a CruiseControl.Net / NAnt setup which I tailored to accommodate the database objects we maintained in our SCM (Perforce).

Currently we have a manual process, but it is still based upon branches in Perforce that consist of database objects (adhoc scripts, tables, alters, views and stored procedures). It works pretty well and generates one file comprising the above components. This makes the deployment process very easy indeed as its a one-click process. [If you are a DBA charged with deploying into Production you should FORCE your developer community to do this!!]