Dynamic reconcilliation framework

Question

Hi,

    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.

 

    

 

Answer 1

have you looked at Merge Replication?

---

Please mark as answer, if this was it. Visit my SQL Server Compact blog

Answer 2

Hi rkaura,

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:

Merge Replication:
http://msdn.microsoft.com/en-us/library/ms152746.aspx

---

Allen Li
TechNet Community Support