RE: Comparing Database Version to VCS (TFS) version in Toad 10.6

Hello Ana,
This is a great question. Team Coding does not have a specific function to do this.  User's will be warned if they attempt to check out objects that have been modified outside of Team Coding. You can also use the 'View Differences' function against individual objects. Neither, will fully accomplish what you need. I think this would be would be a great request for the Toad Idea Pond.

The following approach might work. If you can import your Team Coding objects into another compare schema, you may be able to use the Schema Compare function to do what you need.
In Team Coding Code Collections, do a 'Compile Latest Revision'. In the 'Import Options' dialog, select 'Update another schema'. This will import the objects in the VCS to the test schema. You can then do a Schema  Compare between this schema and your test schema.

Stephen



From: [email protected] [mailto:[email protected]] On Behalf Of Ana Roje Ivancic
Sent: Friday, November 23, 2012 7:21 AM
To: [email protected]
Subject: [toad] Comparing Database Version to VCS (TFS) version in Toad 10.6


Hi!

The environment we set up at a client's site more than a year ago includes versioning Oracle DBs using Toad, Team Coding and TFS2010. They are using MSSCCI provider and Toad 10.6.

Now we are doing a revision of the system, aiming to figure out if they are using versioning according to the rules we defined back then.

Test databases have been imported using Team Coding, and then Team Coding was disabled so that they can not check in changes from the test database.
On the other hand, disabling team coding means that they could have made changes to database objects (although they should not be doing that).


Now we need to see for each object in the DB if there are differences between its state on TFS and its state in the DB.

The direction from DB to TFS can be achieved using the Code Control Groups option "Export to VCS" (I choose the option "Create new revision if the object has not changed").

How can I get the opposite direction - see if there are changed objects on TFS that are not in the database?
I am not allowed to make changes to the database (so I can not do a Get Latest version), but just get the list of differences.
The database is large, so I can not do a diff/compare for each object. I need something on the level of the database, schema or each code control group.

I tried doing an "Import to Database" for a Code Control Group with the option "Create Script", but it creates a scripts for all objects in TFS, not just changed ones.

Any suggestions?

Are there any changes related to diff actions in Toad 11?


Thanks,
Ana