Peter that is not even close to what I want to achieve.
Andrew Scott Senior Coldfusion Developer Aegeon Pty. Ltd. www.aegeon.com.au Phone: +613 8676 4223 Mobile: 0404 998 273 From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Peter Tilbrook Sent: Monday, 16 April 2007 5:11 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Version Controlling a Database 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: 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 > > > > > > > -- 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 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 -~----------~----~----~----~------~----~------~--~---