How to identify difference between two databases' data changes?
Posted on 2013-01-23
I've existing DB called A. I created another DB called B from the backup of A.
I do modification in both databases. Say for example, in database A, in tableA some rows has been inserted. In database B, in tableA some rows has been deleted/modified.
I would like to know the data changes between the two databases. How to identify them? Is there any FREE tool existing for that? Or any other way existing to identify this? Or If I want to implement new tool what approach I've to follow?
Please do guide me.
Note: I'm using SQL SERVER 2008 R2.