Comparing table structure

microsoft.public.sqlserver.tools

7 Mar 2007 12:55 PM

Gaspar

Is there any tool to compare table structures between two databases?

For example: When comparing Table_A and Table_B, which fields are
missing, which relations are missing, etc.

Thanks,
Gaspar

7 Mar 2007 1:03 PM

Hari Prasad

Hello,

SQLCompare from Redgate software is a good DB structure and Data compare
software.

http://www.red-gate.com/products/SQL_Compare/index.htm

Thanks
Hari

Show quote

"Gaspar" <gas***@no-reply.com> wrote in message
news:egp9yfLYHHA.3984@TK2MSFTNGP02.phx.gbl...
> Is there any tool to compare table structures between two databases?
>
> For example: When comparing Table_A and Table_B, which fields are missing,
> which relations are missing, etc.
>
> Thanks,
> Gaspar