The comparison does not highlight column changes independly of just order changes. Toad handles this - can redgate?
The comparison does not highlight column changes independently of just order changes. Toad handles this - can redgate?
I need to see column differences independently of field order which are not as important. How do I do this in redgate
5
votes
Rich Swain
shared this idea
-
Kevin Woolfe
commented
If the “Ignore Column Order” flag is set and a table is selected in the upper comparison window, then the DDL generation in the second comparison window should sort the table’s columns alphabetically. Oracle Schema Compare is probably using dbms_metadata to build the DDL, so some string parsing would need to be done after the fact. Alternatively, the DDL could be built by querying the dba_tab_columns table and including an ORDER BY clause on the column_name instead of the column_id.