RE: Team Coding with Subversion in Toad 11

Hello Bogdan,

Each VCS Provider is handled slightly differently in Team Coding.

Modifying the TC_GROUPS by disabling Triggers won't work. I strongly suggest that you delete and re-add your code collections to correct this.

The current SVN configuration in Team Coding does not allow you to select a different working directory for different object types.  The only way to accomplish this is to set up a Code Collection for each object type and map each collection to a different SVN project.  Each project is mapped to its own working directory and Team Coding will save the source files for objects in these directories.

You can't set up mirroring for users as you describe.  To Mirror to a master schema,  you must log in as the user who is not the owner of the Schema in the Code Collection.  I think the TC_ADMIN route you suggest sounds like it has some potential,  and suggest you add it to the Toad Idea Pond.

Please let me know if I can be of any additional assistance

Stephen


From: [email protected] [mailto:[email protected]] On Behalf Of Bogdan Bachis
Sent: Thursday, November 10, 2011 7:01 AM
To: [email protected]
Subject: [toad] Team Coding with Subversion in Toad 11



Message from: bachisb


I'm trying to find out a way to do the version control of our database objects using Toad. I've successfully configured subversion but now I have 2 problems: 1. I'm not able to change the working directory / VCS Project to a subdirectory in my SVN-Path when I'm defining a Code Collection. I want to store the database objects in the OBJECTS directory, which has the following path on the svn server: \\DB\OBJECTS In the Code Collection Window I can only specify as a VCS Project the Module Name. Nor is it possible to change the Working Directory. I've found a solution for this (changing the VCS Project in the TC_GROUP Table on the Team Coding Installation Schema, turning the triggers on that table off / on before and after this so that the TC repository doesn't get corrupt) but I'm not very happy with it. 2. Is there a way for an TC Administrator (having the TC_ADMIN_ROLE) to set a schema as mirror schema? I just can do that if I grant the owner of the future mirror schema the TC_ADMIN Role and let him to that. Thanks, Bogdan

_______________________________________

Historical Messages


Author: Bogdan Bachis
Date: Thu Nov 10 04:01:06 PST 2011
I'm trying to find out a way to do the version control of our database objects using Toad. I've successfully configured subversion but now I have 2 problems: 1. I'm not able to change the working directory / VCS Project to a subdirectory in my SVN-Path when I'm defining a Code Collection. I want to store the database objects in the OBJECTS directory, which has the following path on the svn server: \\DB\OBJECTS In the Code Collection Window I can only specify as a VCS Project the Module Name. Nor is it possible to change the Working Directory. I've found a solution for this (changing the VCS Project in the TC_GROUP Table on the Team Coding Installation Schema, turning the triggers on that table off / on before and after this so that the TC repository doesn't get corrupt) but I'm not very happy with it. 2. Is there a way for an TC Administrator (having the TC_ADMIN_ROLE) to set a schema as mirror schema? I just can do that if I grant the owner of the future mirror schema the TC_ADMIN Role and let him to that. Thanks, Bogdan
__
_______________________________________