Modified or new records

  • Thread starter Thread starter T Cordon
  • Start date Start date
T

T Cordon

How can I compare 2 datasets form 2 completely identical tables in 2
different Databases and get only those records that have changed in one of
the DB's or are new?

Thanks
 
Use the primary key and loop through value by value and compare the values
of the row, column by column to get the changed ones. You can use a similar
approach to find new ones, sort on the PK and then

IsNul = (dt1.rows[PkColumn] != dt2.Rows[PkColumn] )

You'll obviously need to cast each to the respective type but the logic is
essentially the same. Or you could build a string of all of the values from
Table one and fire a sql statement with Not In(alloftheValues) and vice
versa..

This is probably much better suited to being handled server side with SQL
Though if at all possible.
 
Is there any other way to compare datasets?

William Ryan eMVP said:
Use the primary key and loop through value by value and compare the values
of the row, column by column to get the changed ones. You can use a similar
approach to find new ones, sort on the PK and then

IsNul = (dt1.rows[PkColumn] != dt2.Rows[PkColumn] )

You'll obviously need to cast each to the respective type but the logic is
essentially the same. Or you could build a string of all of the values from
Table one and fire a sql statement with Not In(alloftheValues) and vice
versa..

This is probably much better suited to being handled server side with SQL
Though if at all possible.
T Cordon said:
How can I compare 2 datasets form 2 completely identical tables in 2
different Databases and get only those records that have changed in one of
the DB's or are new?

Thanks
Click to expand...
Click to expand...
 
Other than rolling your own Compare method, I really don't think so.
T Cordon said:
Is there any other way to compare datasets?

William Ryan eMVP said:
Use the primary key and loop through value by value and compare the values
of the row, column by column to get the changed ones. You can use a similar
approach to find new ones, sort on the PK and then

IsNul = (dt1.rows[PkColumn] != dt2.Rows[PkColumn] )

You'll obviously need to cast each to the respective type but the logic is
essentially the same. Or you could build a string of all of the values from
Table one and fire a sql statement with Not In(alloftheValues) and vice
versa..

This is probably much better suited to being handled server side with SQL
Though if at all possible.
T Cordon said:
How can I compare 2 datasets form 2 completely identical tables in 2
different Databases and get only those records that have changed in
Click to expand...
Click to expand...
one
of
Click to expand...
Click to expand...
 
Back
Top