How to generate metadata delta report for differences between two data models?
Problem Statement: There are two Erwin data model files, one is old one and another one is incremental changes to old one. There is report requirement to list the properties differences between old one and new models, in other words delta report between two models.
The differences categories like Add/Drop/Renamed/Changed
Applicable for properties of objects like Table, Column, Data Type, Constraint, NULL Option, etc.
Any help to generate such custom report will help?
-
Hi,
the Complete Compare functionality is exactly what you need.
Simply compare the old model to the new model (make sure to limit the comparison to object types you are interested in) and apply the differences to the old one. Generate the delta script by clicking the left side/right side alter script button.
Please sign in to leave a comment.
Comments
1 comment