Comparing "equivalent" text values

[lotusman]

Hi,

Just wondering if it's possible to compare "equivalent" programmatic entities. I am comparing Oracle and SQL Server DDL scripts, so the data types vary on a direct compare and I was wondering if we can add "equal" pairs for compares? For example, SQL server varchar and Oracle varchar2, SQL Server datetime, Oracle Date and so forth would be considered the same for comparison purposes.

Thanks
Rob

[Aaron]

Hello,

Beyond Compare 3 Pro has a feature called Text Replacements. Here you could define statements such as
"varchar" on the left and "varchar2" on the right. These two would then be considered equal if aligned with each other. Text Replacements are Session specific, so you would need to either set them as Session Defaults for the Text Compare, or save specific sessions to be loaded later.
If you are currently running Std edition, you can trial Pro by following this guide:
http://www.scootersoftware.com/suppo...?zz=kb_evalpro


Alternatively, you could define those specific entries as Unimportant (in general) in the Std edition.
http://www.scootersoftware.com/suppo..._unimportantv3

How does that work for you?