Options

Total differences in script?

Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
edited September 23, 2004 5:30PM in SQL Toolkit Previous Versions
Hi,

Do you need a report of the schema differences or the data differences?

Comments

  • Options
    Hi,

    Just to count the different records (not missing or additional), you can get this information from the ResultsStore's RowCount property:

    foreach (Table table in commonTables)
    {
    ResultsStore differenceStore=session.TableDifferences[table.FullyQualifiedName].DifferentRecords;
    DifferencesCount+=differenceStore.RowCount;
    }
This discussion has been closed.