asked on

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.

appari

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.

Easwaran Paramasivam

ASKER

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.

appari

so you just want to know the differences only?

appari

this tool from redgate helps in comparing schemas
http://www.red-gate.com/products/sql-development/sql-compare/

Easwaran Paramasivam

ASKER

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.

Easwaran Paramasivam

ASKER

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?

appari

trail version is available for download. you can download and use it to do the work.

SOLUTION

appari

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ASKER CERTIFIED SOLUTION