DEV, TEST, PROD. What else can you do? On 16/04/07, Andrew Scott <[EMAIL PROTECTED]> wrote: > > Ok, > > Now it seems that everyone is getting the wrong end of the stick here, the > scenario is going to be simple. This is for development only, and we are in > the middle of a huge project with many developers working away, we have > already introduced TDD with XP Agile development and have everyone using SVN > for creating different versions. > > But the problem now is the database, if we need to support n versions of > an application we are finding that the database requires more work and > maintenance than it really should when switching between different branches > of our code. > > So as someone mentioned I would not be looking for a solution for > production, come on guys I have been developing long enough to not make a > stupid move like that. The problem is that we currently use RedGate as I > said earlier and its works well for MS SQL Server, but it doesn't work for > mySQL or Oracle or DB2. > > Now if you look at having to switch to a different branch of code to > maintain, there really needs to be someway to do this with SQL schemas as > well. > > And yes we have daily backups, but this is not the issue. > > > > > > >
-- 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 -~----------~----~----~----~------~----~------~--~---