Iterating through the actual differences

arbo

Having identified each object that appears to be different - is there any way of showing the actual SQL code of the two compared objects and the lines that are actually different?

I need to compile a report that identifies the objects that are different / new and how they differ.

Best wishes,
Arne

Brian Donahue

Hello Arne,

Schema-wise, you can get to the underlying SQL code of an object using Work.ScriptObject(obj):

for(int i = 0; i <= obDatabaseDifferences.Count-1; i++) 
         { 
            Difference diff = (Difference)obDatabaseDifferences[i]; 
            Work w = new Work(); 
            Regions regions1 = w.ScriptObject(diff.ObjectIn1, enOptions); 
            Regions regions2 = w.ScriptObject(diff.ObjectIn2, enOptions); 
}

arbo

Thanks Brian,

It works nicely.

Arne