Re: Managing application and database version dependencies

2010-05-07 Thread Greg Harris
It is also worthwhile to check the environment at the same time, I have a flag for development test and production, you do not want to run tests against your production database! On Fri, May 7, 2010 at 3:06 PM, David Richards ausdot...@davidsuniverse.com wrote: I have a Version table that has

RE: Managing application and database version dependencies

2010-05-06 Thread Greg Keogh
Matt, I like to put two magic numbers in a special database table: The change number, The compatibility number. The first increments whenever the schema changes. The second increments only when a breaking change is made. The app startup code can use these numbers to determine if it can run

Re: Managing application and database version dependencies

2010-05-06 Thread Matt Siebert
As soon as I read 'compatibility number' in your email I remembered we discussed this internally long ago. Just recently I was thinking of tracking the required version for each app that connects to the database but after thinking about it I don't think we'll need that level of granularity. A

Re: Managing application and database version dependencies

2010-05-06 Thread David Richards
I have a Version table that has a single column, single row with a version number in the form A.B.C.D. I started doing this to follow the same version standard as my apps. So the number would be: A - Breaking change B - Non breaking change (eg additional table, additional column with default) C