When we compare databases or er models we make assumptions on when we will use the schema name in the compare. We make the assumptions based on whether the user chooses ALL_SCHEMA or a specific SCHEMA name when choosing the objects to compare. If you choose a specific SCHEMA for target and source, then we don't include the schema name, while if you choose ALL_SCHEMA for both, then we do include schema name.
When comparing two ER models we don't ask the user to choose the objects, and instead just do a full object compare. And, we include the schema name for compare. We either need to ignore the schema or prompt the user to choose whether they want to include the schema name.
See ERFrame.compare() ... here we pass the options for the compare and send a value to not ignore the schema name.
When user launches Tools > Compare, have a new dialog that pops-up.
That dialog will have a LHS in which the user can choose the file to compare against. (this is similar to the File Compare dialog). The RHS is pre-populated with the existing ER diagram file name (or window name) and cannot be changed. Below these section is a third section that lists all the schema compare options.
Changes to ER Modeler Tool:
- Renamed "Compare" action to "Compare with Model"
- Affter user chooses a ER Diagram file for Compare with Model, a dialog is displayed. The dialog allows the user to choose a different ER Diagram file and to toggle different compare options.
Changes to ER Modeler Tool:
- Renamed "Compare" action to "Compare with Model"
- Affter user chooses a ER Diagram file for Compare with Model, a dialog is displayed. The dialog allows the user to choose a different ER Diagram file and to toggle different compare options.
Issue #10697 |
Closed |
Fixed |
Resolved |
Completion |
No due date |
Fixed Build ADS 14.0.4-3 |
No time estimate |
2 issue links |
relates to #10740
Issue #10740Compare with Model should have db specific options in ER Modeler |
relates to #14407
Issue #14407ERM -> DB2 i Series -> Script Constraint is missing constraint schema & name |
When user launches Tools > Compare, have a new dialog that pops-up.
That dialog will have a LHS in which the user can choose the file to compare against. (this is similar to the File Compare dialog). The RHS is pre-populated with the existing ER diagram file name (or window name) and cannot be changed. Below these section is a third section that lists all the schema compare options.