How to identify difference between two databases' schema 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 a new column has been added. In database B, in tableA a column has been dropped.
I would like to know the schema changes. 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.