One of the features of the older TOAD's comparison tool was that it allowed for the details of the comparison to be seen. This made it easier to see exactly differences were being addressed by each of the items. In the current Compare Schema, the functionality to see the details is there, but it requires a mouse click to pop-up the screen, and another to remove the screen. When each difference is being reviewed and there are hundreds of differences, this makes the review process take much longer than required.
What I would like to see changed is on the "Difference Details" tab, to make the it into a split screen, such that the existing Tree View would be displayed on the left hand side, and on the right hand side that two more panes be displayed with right top pane containing the detail view and the bottom pane showing the DDL Script. This would eliminate streamline the review process and drastically reduce the amount of effort required for large reviews.
On a separate topic, TOAD is currently not supporting an automated approach to re-order columns of a table if DBMS_REDIFINITION is not available. (our DBAs will not allow us to use the DBMS_REDIFINITION package because of security concerns). What I would like to see is an option that would create a script like this: Rename Table to some temp name, drop all triggers, FK, indexes etc from the table, create table using correct ordering of columns, add indexes, triggers, FK, etc. These are the steps that we are doing manually. Obviously, the DBMS_REDIFINITION package would be the preferred approach is it doesn't require downtime, but at least if this were a choice, then the manual work to recreate the table could be eliminated.
Thanks for listening and love the tool!
I'm wondering about your need to run DBMS_REDEFINITION. Why would you need to reorder the columns of a table? I can understand that you might have problems getting the DBA to approve its use, but unless you have some varchar2 data types that star small and end up being updated to large, that need moving to the "end" of the row, I'm puzzled as to why you need to reorder.
that helps, thanks.