Check out?

Track changes to Oracle schemas in your existing version control system.

Check out?

Postby Paule » Mon Sep 09, 2013 7:39 pm

I haven' t testet the product yet. But one thing is unclear to me.
If multiple developers start to work on the same procedure, how can they check out an db Object so that anybody Else could Not Modify it too?
Posts: 3
Joined: Mon Sep 09, 2013 7:27 pm

Postby neil.anderson » Mon Sep 09, 2013 7:49 pm


Thanks for your post. Assuming you are talking about the situation where multiple people are working on the same Oracle instance you can "check out" or lock an object as outlined here: ... ng+objects

The developer locks an object from modifications and until he unlocks it other users are prevented from modifying it. He can continue to work and other users will get an error if they try to change it.

Posts: 64
Joined: Tue Sep 28, 2010 1:17 pm

Postby Paule » Sun Sep 29, 2013 9:43 am

OK, locking is working.
We now try to evaluate Redgate Source Contol in combination with TFS in the team.

For me it is not 100% clear, how we can manage a "central" locking?

Let's look at the following scenario for instance:

1. Two developers start to work on the same Oracle package at the same time. The are using different databases.
2. They check their current version and get the latest version from TFS via Redgate and start to work.
3. After some time Developer 1 check in his new version containing a new procedure 'a' into TFS via Redgate.
4. Afterwards Developer 2 check in his new version containing a new procedure 'b' into TFS via Redgate, but procedure 'a' is missing in the latest version.

How to handle such a scenario?
Why is a central locking in e.g. TFS not supported?
Posts: 3
Joined: Mon Sep 09, 2013 7:27 pm

Postby Michael Christofides » Wed Oct 09, 2013 3:56 pm

Hi Paule,

I work with Neil on the Oracle team, as Product manager I feel perhaps locking is still a confusing feature of the tool.

Our aim with locking was to provide teams working on shared development schemas a means by which to 1) avoid clobbering each others' changes accidentally and 2) communicate what they were working on to one another.

The use case you describe is something we see less, but that we understand would be valuable to some teams working on separate, sand-boxed, development schemas. We currently see a better long-term solution to that problem to be to offer a "merge" to the second person, but in the meantime we currently offer a "take mine" or "take theirs" to resolve the conflict. There is nothing stopping you at that point going to either the database or the file system and merge the object yourself.

Hopefully that helps?

Best regards,
Michael Christofides
Posts: 97
Joined: Wed Apr 20, 2011 5:37 pm
Location: Red Gate Software

Return to Source Control for Oracle

Who is online

Users browsing this forum: No registered users and 0 guests