|
Home > Archive > MS SQL Server > January 2006 > Comparing 2 SQL Server Database schemas
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Comparing 2 SQL Server Database schemas
|
|
| hatsumoto@gmail.com 2006-01-24, 8:23 pm |
| 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
| |
| Frank Rizzo 2006-01-24, 8:23 pm |
| 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
>
| |
| Sue Hoegemeier 2006-01-24, 8:23 pm |
| 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
| |
| sualeh.fatehi@gmail.com 2006-01-31, 9:23 am |
| 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
|
|
|
|
|