Friday, December 07, 2012 12:45 AM
I need to design a reconcilliation framework. That does the below:
1) Compares the data between the target and the source and obtain the delta i.e. data present in source and not in target. and also data present in target and not in sournce.
2) There might be a few records that exist in both the systems but where there is a column mismatch between the records. i.e.. the primary key value matches but the values in some of the other columns do not match. In that case i need to report the mismatched row along with the the differing value in source as well as the target(columns). This i need to do for all the columns that do not match.
Also for point 2,i need to provide a functionality to turn off and turn on the columns that can be matched.
Friday, December 07, 2012 1:45 PMModeratorhave you looked at Merge Replication?
Please mark as answer, if this was it. Visit my SQL Server Compact blog
Monday, December 10, 2012 2:30 AMModerator
If you want to synchronize the data between target table and the source table, we can use Merge Replication; if you just need to get the in target table but not in the source table, we can use outer join operator to connect these two tables, and filter out the result. For example:
select a.Param1, a.Param2 from TableA a outer join TableB b on a.ID = b.ID where a.Param1 <> b.Param1 or a.Param2 <> b.Param2
For more detail information, please refer to the following link:
TechNet Community Support