I want to do a schema compare that will tell me if there is a difference in table columns' datatypes. For example, if column DEPNO in table EMP is NUMBER in schema 1 and is NUMBER (2) in schema 2. How can this level of detail of column difference be generated in a file once the comparison is completed?
There is an option on the Options | Object Type Specific Options tab, in the Misc section, called “Compare column scale, precision, & length”. Checking this option will allow you to compare to the level of detail you are looking for.
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center