Skip to main content

Questions on IDEA Analysis

Comparing 2 Databases completely

I have some tasks for which i am using IDEA to import and export data. At the end of the task i need to check whether the exported files are exact replica of the initial databases (Strucutre is the same, but the content needs to be verified) when later imported again in IDEA by someone else.
I know IDEA has a function for comparing databases that but that seems limited on the limited number of fields. I want to check all fields for all records in 2 databases, was hoping for an easy solution to exist any starting point taken in that area?

Identifying Duplicates using @SoundsLike

I can use @SoundsLike to find matches to static strings I enter into the equation or two fields on the same record.  But I don't know how to use @SoundsLike to match any one record with any similar record in the same file because I don't know how to reference the same field from two records as parameters to the function.  Any suggestions?  Is what I'm trying to do possible?