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
![](https://secure.gravatar.com/avatar/7950b1f40f24cde767a6328e82f085c1?size=40&default=https%3A%2F%2Fassets.uvcdn.com%2Fpkg%2Fadmin%2Ficons%2Fuser_70-6bcf9e08938533adb9bac95c3e487cb2a6d4a32f890ca6fdc82e3072e0ea0368.png)
-
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.