Thursday, March 22, 2012

Comparing data model

All,
An up gradation is going on in my project. Here, I have some tables
in a project specific database and the same (w.r.t name) set of tables
(but the modified one) in a different database. We are using
sqlserver2000.
Now I need to find out what are modifications- means the name &
features of the new columns.
Just by looking the table's structure and manually comparing it, the
work can be done.
If any one knows any approach that can compare the two tables (with the
same name residing in different db) then the work can be done more
effectively.
Any input will be highly appreciated.Not sure if this is what you need. There is a tool to compare
schema/structure of databases, Red Gate SQL Compare. www.red-gate.com.
Ben Nevarez, MCDBA, OCP
Database Administrator
"MUKUT" wrote:

> All,
> An up gradation is going on in my project. Here, I have some tables
> in a project specific database and the same (w.r.t name) set of tables
> (but the modified one) in a different database. We are using
> sqlserver2000.
> Now I need to find out what are modifications- means the name &
> features of the new columns.
> Just by looking the table's structure and manually comparing it, the
> work can be done.
> If any one knows any approach that can compare the two tables (with the
> same name residing in different db) then the work can be done more
> effectively.
> Any input will be highly appreciated.
>|||If you are willing to use a Java-based tool in your environment, you
can use SchemaCrawler, a free open-source tool that can compare schemas
as well as data. SchemaCrawler is a command-line tool to output your
database schema and data in a readable form. The output is designed to
be diff-ed with previous versions of your database schema.
http://schemacrawler.sourceforge.net/
All you will need is a JDBC driver, a good free one is jTDS
(http://jtds.sourceforge.net/) and any diff tool such as WinMerge.
Sualeh Fatehi.

No comments:

Post a Comment