Comparing 2 SQL Server Database schemas

Hi,
I was wondering if there is any way I can compare the database schemas
of 2 MS SQL Server databases? I would like to know if there are any
missing tables, missing table columns, table indices etc. from the
databases.

Any tools I can use would be greatly appreciated..

Regards and many thanks in advance,
Hat

hatsumoto@gmail.com  wrote:
> Hi,
> I was wondering if there is any way I can compare the database schemas
> of 2 MS SQL Server databases? I would like to know if there are any
> missing tables, missing table columns, table indices etc. from the
> databases.
>
> Any tools I can use would be greatly appreciated..

Check out SQL Effects Clarity from http://www.sqleffects.com
The tool gives you exactly what you asked, plus a really cool
synchronized side by side schema views of both databases.



>
> Regards and many thanks in advance,
> Hat
>

Red-Gate Software has two compare tools - SQL compare (for
schema) and SQL Data Compare (for data).
http://www.red-gate.com

-Sue

On 24 Jan 2006 15:10:16 -0800, hatsumoto@gmail.com wrote:

>Hi,
>I was wondering if there is any way I can compare the database schemas
>of 2 MS SQL Server databases? I would like to know if there are any
>missing tables, missing table columns, table indices etc. from the
>databases.
>
>Any tools I can use would be greatly appreciated..
>
>Regards and many thanks in advance,
>Hat

SCT (SQL Server Comparison Tool) might be the tool which you are
looking for. It's main purpose is to compare databases, for example to
detect if some data changed, or the structure of tables, stored
procedures, etc. But it can be also used to view data and/or objects
of one database - tables, procedures, functions, views, triggers,
relationships. For example you can quickly see how many records are in
the tables and do some basic reporting.

You can download fully functional demo version of SCT from
http://www.sql-server-tool.com/

HTH

If you are willing to use Java, there is a free open-source tool called
SchemaCrawler on SourceForge that can compare schemas (and data)
between databases on two different servers.

Download SchemaCrawler from:
http://sourceforge.net/project/show...group_id=148383