Well you can roll back the schema but obviously not that data. We add columns, rarely remove anything.
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:15 AM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Version Controlling a Database Dale, But how do you take those updates, and then realise that at some point in the past a field that was part of the DB was there, then it is no longer then and you want to roll the database back to that version? I looked at Redgate SQL Bundle and snapshots and that seems to be ideal, as well as DTL which will work, but as you know this is only MSSQl Server aware. 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 Dale Fraser Sent: Monday, 16 April 2007 5:12 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Version Controlling a Database 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 --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
