Multi SVN repositories with Team Coding 6 in Toad 10.6

Toad for Oracle
1

Hello,

I currently set up team coding 6 in our Oracle database development DB_DEV.

Two teams will use the team coding on this same db, each team has a different schema in the db with their objects.

Each team has it’s own SVN repository REP_TEAM1 and REP_TEAM2 --> and this point is the object of my question

I configure group control for the first team, and developers login into the vcs REP_TEAM1 --> No problem.

Now I’ll prepare the same for the second team, but during the preparation, I have the feeling that something will not work since I see the vcs_db field in the tc_config which is updated by the repository of the last login. Whether team1 or team2. So I 'm afraid to have conflicts during parallel team coding with REP_TEAM1 and REP_TEAM2.

Is it true? Or Toad don’t use this field and several instances of toad can works simultaneously with differents repositories in the same DB?

If not, is there a workaround?

Thank you very much,

Sébastien.

2

Hi Sebastien,

Toad 10.6 is a very old version, and Team Coding has gone through some major changes since that version. If possible, I would highly recommend upgrading your version of Toad to Toad 12.9. In that version, it’s quite easy to set up the environment the way you’d like. All you would need to do is create two Team Projects:

  1.  The first pointing to the first team’s schema, which is linked to its corresponding SVN project folder (REP_TEAM1)

  2.  The second pointing to the second team’s schema, which is in turn linked to its corresponding SVN project folder (REP_TEAM2)

You can then specify object filters to further restrict which objects are controlled by Team Coding. You can also enforce code analysis metrics on PL/SQL code to make sure everyone’s code follows standard company practices. Once you have those projects set up, everything in Team Coding should work naturally.

If you need to stay with Toad 10.6, I would try to create two Code Control Groups: one for the first schema and one for the second schema. Attach each schema to its corresponding Subversion project folder. That should work. For further information about using Subversion with Team Coding in Toad 10.6, I’d recommend checking out the following blog:

http://www.toadworld.com/products/toad-for-oracle/b/weblog/archive/2010/11/15/configuring-toad-174-team-coding-to-use-apache-subversion-updated

For further information regarding setting up Team Coding in Toad 12.9, see the following Getting Started guide here:

http://www.toadworld.com/products/toad-for-oracle/b/weblog/archive/2016/06/21/getting-started-with-team-coding-new-for-toad-for-oracle-2016

-John

From: Sebastien Tromme [mailto:bounce-Sebastien_Tromme@toadworld.com]

Sent: Tuesday, August 23, 2016 10:43 AM

To: toadoracle@toadworld.com

Subject: [Toad for Oracle - Discussion Forum] Multi SVN repositories with Team Coding 6 in Toad 10.6

Multi SVN repositories with Team Coding 6 in Toad 10.6

Thread created by Sebastien Tromme

Hello,

I currently set up team coding 6 in our Oracle database development DB_DEV.

Two teams will use the team coding on this same db, each team has a different schema in the db with their objects.

Each team has it’s own SVN repository REP_TEAM1 and REP_TEAM2 --> and this point is the object of my question

I configure group control for the first team, and developers login into the vcs REP_TEAM1 --> No problem.

Now I’ll prepare the same for the second team, but during the preparation, I have the feeling that something will not work since I see the vcs_db field in the tc_config which is updated by the repository of the last login. Whether team1 or team2. So I 'm afraid to have conflicts during parallel team coding with REP_TEAM1 and REP_TEAM2.

Is it true? Or Toad don’t use this field and several instances of toad can works simultaneously with differents repositories in the same DB?

If not, is there a workaround?

Thank you very much,

Sébastien.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle Forum notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.

3

Hi Sebastien,

My apologies: I may have misunderstood your original question.

If you’re looking to connect to two separate projects (REP_TEAM1 and REP_TEAM2) within a single repository, the above recommendation should work just fine. However, if you have two completely separate Subversion repositories (one for each team), this will not work with Toad 10.6 (or even Toad 12.9). While current versions of Toad can link a database to multiple projects within a repository, they can only link a database to a single Subversion repository.

If your original question was in regards to the latter scenario, Toad 12.10 (when it’s released) will allow you to do what you’re looking for. It will simply require the help of a couple additional servers (or virtual machines), but it will also provide you the ability to do some web-based reporting on the quality of code in question. In Toad 12.10, you will be able to manage your Team Coding configuration from Toad Intelligence Central (version 3.2 is required for this). So, to accomplish this task in Toad 12.10 (when it’s released):

Server Setup:

  1. Set up two virtual machines (or spare servers) and install Toad Intelligence Central 3.2 Community Edition onto each server. Each team will have its own server.
  2. Configure users for each team in their respective Intelligence Central server.

Toad Setup - First Team:

  1. Open Toad 12.10 and log into the database in question.
  2. Create a connection to the first Toad Intelligence Central server within Toad.
  3. Open the Team Coding Configuration window and install Team Coding to that Intelligence Central server.
  4. Configure Team Coding for the first team, mapping their schema to their respective Subversion repository, and save the configuration.
  5. (Optionally), add the other team’s schema and freeze all objects so that team cannot change the other team’s schema objects.

Toad Setup - Second Team:

  1. Disconnect from your database session.
  2. (Optionally) delete your first Intelligence Central connection within Toad.
  3. Create a new connection to the second Intelligence Central server, and make sure that’s the active connection in Toad.
  4. Reconnect to the database.
  5. Open the Team Coding Configuration window and install Team Coding to the second Intelligence Central server.
  6. Configure Team Coding for the second team, mapping their schema to their respective Subversion repository, and save the configuration.
  7. (Optionally), add the other team’s schema and freeze all objects so that team cannot change the other team’s schema objects.

Toad Setup - Client machines

  1. Make sure each client has a connection defined to its respective Intelligence Central server.
  2. Members of Team 1 will have their connection pointing to the first Intelligence Central server
  3. Members of Team 2 will have their connection pointing to the second Intelligence Central server

When a member of a given team connects to the database, Toad will look in their defined Intelligence Central server for their specific Team Coding configuration. Code Analysis and Code Tester metrics will also be saved to their respective team’s Intelligence Central server for historical reference and web reporting. And you will be able to view the reporting for each team simply by logging into each team’s Intelligence Central server.

-John

4

Hello John,

Thank you for your attention and your fast answer.

I take into account your recommendation to migrate to a more recent version of Toad.

Concerning my question, indeed, I have two completely separate Subversion repositories (one for each team). So only possible to do this with toad 12.10

Have you an idea of the release date toad 12.10 ?

Kindest regards,

Sébastien.

5

We usually have our release around Oracle Open World which is the week of September 18 so expect an announcement around that time.

From: Sebastien Tromme [mailto:bounce-Sebastien_Tromme@toadworld.com]

Sent: Tuesday, August 23, 2016 4:08 PM

To: toadoracle@toadworld.com

Subject: RE: [Toad for Oracle - Discussion Forum] Multi SVN repositories with Team Coding 6 in Toad 10.6

RE: Multi SVN repositories with Team Coding 6 in Toad 10.6

Reply by Sebastien Tromme

Hello John,

Thank you for your attention and your fast answer.

I take into account your recommendation to migrate to a more recent version of Toad.

Concerning my question, indeed, I have two completely separate Subversion repositories (one for each team). So only possible to do this with toad 12.10

Have you an idea of the release date toad 12.10 ?

Kindest regards,

Sébastien.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle Forum notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.