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, an SP has been updated. In database B, a new trigger and user defined function has been created.
I would like to know the Programmability changes such as difference between SPs, Triggers, UDFs, 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.