Version control and branching when using Oracle

Posted by Ed Woodcock on Server Fault See other posts from Server Fault or by Ed Woodcock
Published on 2010-01-27T11:33:29Z Indexed on 2010/03/30 14:03 UTC
Read the original article Hit count: 350

Filed under:
|

Hi folks:

At work we're using Oracle and C#/ASP.net to handle a customer's website, this site is very large-scale so the database is very large.

We use Perforce for our version control, and tack create or replace scripts to FogBugz cases whenever a database change, which has been fine until now, as we are now at a point where five developers are working on five expansions for the system, each on a seperate Perforce branch. Unfortunately, we cannot get duplicate databases, due to the database size, so everyone is still working from the same one. This is obviously a cause of problems: only ten minutes ago we had a bit of an issue where a stored procedure change for a branch propagated over to the Pre-Production server and caused a large number of crashes for the testers. Ideally, we would like a way to track these changes without having to manually keep track of them through FogBugz.

My question is: how do you lot handle this situation? I'm sure there must be a good way by now to handle versioning, or at least tracking changes, in an Oracle database.

© Server Fault or respective owner

Related posts about Oracle

Related posts about versioning