Perhaps for deletion FLAG it in someway - but retain the data. eg: Open or Closed or Archived. Still in the database (for archive purposes) just not as obvious. I will be doing something similar for a new project. Of course peridiocally doing EXPORTS to a seperate database to keep the db size at a manageable level.
On 16/04/07, Andrew Scott <[EMAIL PROTECTED]> wrote: > > > 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: [email protected] [mailto:[EMAIL PROTECTED] On > Behalf > Of Haikal Saadh > Sent: Monday, 16 April 2007 4:54 PM > To: [email protected] > 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 > > > > > > > > > > > > > > > > > > > > -- Peter Tilbrook ColdGen Internet Solutions President, ACT and Region ColdFusion Users Group PO Box 2247 Queanbeyan, NSW, 2620 AUSTRALIA http://www.coldgen.com/ http://www.actcfug.com/ Tel: +61-2-6284-2727 Mob: +61-0432-897-437 Email: [EMAIL PROTECTED] MSN Messenger Live: Desktop General --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to [email protected] 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 -~----------~----~----~----~------~----~------~--~---
