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

Ana Roje Ivančić <[email protected]>
Newsgroups gmane.comp.db.oracle.toad.free
Message-ID <[email protected]>
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
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.