I am working on a project that includes versioning Oracle DBs using Toad, Team
Coding and TFS2010. We are using MSSCCI provider and Toad 10.6
While setting the environment, I have worked as the domain user tfssetup .
I have successfully set up versioning, configured code control groups and
exported DB object to TFS. Check out/check in logic worked as expected.
The code control groups are configured in the way that one code control group
exists for each DB schema and object type. For example, we have
SCHEMA_1-Functions, SCHEMA_1-Views, ect., SCHEMA_2-Functions, SCHEMA_2-Views,
When configuring Code Control Groups in the dialog “Code Control
Groups”, in the dialog “Add Group” or “Remap
Group” I have used my local path for the value of “Working
Directory”. This is the same directory where the object belonging to
this group are mapped inside my default TFS workspace on my machine.
The problem appeared when another domain user started working with DB objects
that are now under version control.
When he clicks on an object in Schema Browser the TFS logon dialog
“Connect to a Team Foundation Server” appears. If the user clicks
OK, then the “Choose Folder in Team Foundation Server” dialog
appears and the user can select the team project and his workspace. The value of
the “Local Path” in this dialog is set to the local path I have
previously set up on my machine and cannot be changed (the Browse button is
disabled). If the user chooses his own workspace, the local path value does not
If he, on the other side, clicks cancel on the TFS logon dialog, then he cannot
work with versioned objects. The error “Unable to get revision from VCS
repository.” appears as soon as he tries to checkout an object.
The TFS logon dialog appears more times if the user clicks Cancel.
The only way that I see now how this second domain user can set his working
folder is to go to Code Control Groups and remap each group.
When we tried this, then again, when I logged as tfssetup, I was asked the same
thing to log on to TFS and set up my working folders.
I would like to know why Team Coding behaves this way?
Have we configured everything in the right and expected way?
Is there any general setting that prevents this behavior?
We plan to use about 60 Code Control groups and cannot set up an environment
where users must constantly remap code control groups to their local working
Why Team Coding and MSSCII provider do not work in sync and use TFS workspace
settings to find out the mappings to local folders?
Thank you very much in advance,