We have as part of our application a database upgrader, which upgrades databases through code executing sql statements.
The beauty of this is when you change a table, you add the change in code to the updater and run it, it does some clever stuff like check what it's up to so it doesn't apply upgrades that already exist. But then all the code is in SVN and thus you have a history of all schema changes also. Regards Dale Fraser http://dale.fraser.id.au/blog -----Original Message----- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Andrew Scott Sent: Monday, 16 April 2007 5:06 AM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Version Controlling a Database Btw thinking about this more, this method will not work and the reason being is how would you roll back to a previous version? You can't, without writing more scripts to do this for you... Which is defeating the purpose. Andrew Scott Senior Coldfusion Developer Aegeon Pty. Ltd. www.aegeon.com.au Phone: +613 8676 4223 Mobile: 0404 998 273 -----Original Message----- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Haikal Saadh Sent: Monday, 16 April 2007 4:54 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Version Controlling a Database I presume you mean versioning the schema rather than the actual data? One way would be to only modify your schema using scripts (CF, or SQL). Then you can shove these into SVN. If you have scripts for each revision, you can then roll forward from versions in a fairly arbitrary manner. Andrew Scott wrote: > Has anyone thought about this, or is there anyone out there doing this? > > Pros and Cons woud be good please, and we use SVN so would prefer to > integrate into that and need be a non DB specific as well. > > > Andrew Scott > Senior Coldfusion Developer > Aegeon Pty. Ltd. > www.aegeon.com.au > Phone: +613 8676 4223 > Mobile: 0404 998 273 > > > > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~----------~----~----~----~------~----~------~--~---
