Single Table comparison using SDK
Riyas
Posts: 2
Hi,
I would like to compare a single table using SDK and export the results to excel/PDF etc. The results should be in different files like - SourceTargetMacthingRecords.xls, SourceTargetMismatchRecord.xls etc.. I tried to go through the sample code, but it compares the entire database tables and loop through each of them (see below) and it takes long time. Is there a way I can only do compare on a single table and export the results based on match/mismatch on different files.
// Create the mappings between the two databases
TableMappings mappings = new TableMappings();
mappings.CreateMappings(db1.Tables, db2.Tables);
session.CompareDatabases(db1, db2, mappings);
foreach (TableMapping mapping in mappings)
{
}
Thanks,
Riyas
I would like to compare a single table using SDK and export the results to excel/PDF etc. The results should be in different files like - SourceTargetMacthingRecords.xls, SourceTargetMismatchRecord.xls etc.. I tried to go through the sample code, but it compares the entire database tables and loop through each of them (see below) and it takes long time. Is there a way I can only do compare on a single table and export the results based on match/mismatch on different files.
// Create the mappings between the two databases
TableMappings mappings = new TableMappings();
mappings.CreateMappings(db1.Tables, db2.Tables);
session.CompareDatabases(db1, db2, mappings);
foreach (TableMapping mapping in mappings)
{
}
Thanks,
Riyas