[Phpug] Continuous integration and databases

[Cormac Parle]

I believe there was a talk on this at php|tek, someone had a way of 
doing it using svn ... we use cvs here though, and I've enough to worry 
about on this project without that



Sonic Donic wrote:
> On Wed, May 21, 2008 at 3:22 PM, Cormac Parle <cormac at morsolutions.com>
> wrote:
> 
>> If so - what do you do about an application's database? Is there any way
>> to track changes to the DB schema that you can then apply to the
>> staging/live db without affecting the data?
>>
> 
> I'm not too sure about this but I think if you use CruiseControl with DBUnit
> you might get kind of close to what you are looking for (except for the data
> migration). I've looked and re-looked for a solution to the same problem
> numerous times but I've been told it's the holy grail of CI.
> 
> Just on a side note, I think your initial definition of CI is a bit off in
> that the codebase should be checked out and tested after each check-in. This
> way failing tests are fixed (preferably) before anyone else has a chance to
> update from the repo. Although, this might be more in the realm of the
> extreme programming end of CI.
> 
> It would be good to hear about what you end up doing.
> 
> Cheers,
> 
> Sonic
> _______________________________________________
> Phpug mailing list
> Phpug at lists.iephpug.org
> http://lists.iephpug.org/mailman/listinfo/phpug
> Member Map http://www.frappr.com/irishphpusersgroup/
> Membership Planner Calendar: http://tinyurl.com/opjd5
> 
> 

-- 

-----
morsolutions -  create | innovate | integrate

w: www.morsolutions.com
t: 041 980 1000
f: 041 980 1001
a: Unit B201, An tSean Mhargadh, Green Lanes, Drogheda, Co. Louth

For Support: helpdesk at morsolutions.com
For Sales: sales at morsolutions.com

A member of MIDAS MultiMedia, A Creative and Digital Media Cluster - 
http://www.midasmultimedia.com

Shortlisted for Web Developer Excellence Award in the Net Visionary 
Awards, 2007
Shortlisted for Best Business to Business Award in the Drogheda Business 
Excellence Awards, 2007
Winners of Best Innovation Award in the Drogheda Business Excellence 
Awards, 2006
Winners of LCEB Enterprise of the Year, 2003

Whatcar.ie (www.whatcar.ie) - Winner of Online Trader Award in the Net 
Visionary Awards, 2007
Irish Motoring (www.irishmotoring.ie) - Shortlisted for Best Innovation 
Award in the Drogheda Business Excellence Awards, 2007
Mumstown.ie - Shortlisted for Best Innovation Award in the Drogheda 
Business Excellence Awards, 2007
Irish Motoring (www.irishmotoring.ie) - Shortlisted for Best Education 
Website in the Golden Spider Awards, 2006 and 2007


morsolutions is the trading name of Maher O'Rourke Limited.
Company registered in Ireland No. 328973.
Registered office: Unit B201, An tSean Mhargadh, Green Lanes, Drogheda, 
Co. Louth, Ireland