How to identify difference between two databases' schema changes?

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.
LVL 16
Easwaran ParamasivamAsked:
Who is Participating?
 
appariCommented:
Do you want to keep both the databases same all the time or you just want to know the changes? if you want to keep both the databases same you can try replication available in sqlserver.
0
 
Easwaran ParamasivamAuthor Commented:
Not in same time. A database in used in my application version 1.0 and B database is used in application version 2.0.

Note: I'm using SQL SERVER 2008 R2.
0
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

 
appariCommented:
so you just want to know the differences only?
0
 
appariCommented:
this tool from redgate helps in comparing schemas
http://www.red-gate.com/products/sql-development/sql-compare/
0
 
Easwaran ParamasivamAuthor Commented:
Once I know the difference, I need to upgrade the schema from lower version to higher version (means a common database which works in my application version 2.0). I know already database B works for application version 2.0. But I would like to incorporate the changes done in database A as well. So that I no need to maintain two databases.
0
 
Easwaran ParamasivamAuthor Commented:
Found sqlcompare is useful. It is commercial one. Any such kind of free tool available? If not, I would like to create my own tool. Please guide me how to achieve that?
0
 
appariCommented:
trail version is available for download. you can download and use it to do the work.
0
 
appariConnect With a Mentor Commented:
freetool http://dbcomparer.com/ i never tried it so can't say how it works
0
 
Easwaran ParamasivamAuthor Commented:
Thanks.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.