Compare tables layout in dev and prod

Hi,
Does anyone know that without the tool, how to compare table's layout those
are existing development and production servers?
Regards,
-Chen
Hi,
You could use INFORMATION_SCHEMA.COLUMNS Views.Put the contents into a table
and compare.
SQLCompare from Redgate software has got a very good tool for data and
schema comparison.
http://www.red-gate.com/sql_tools.htm
Thanks
Hari
SQL Server MVP
"Chen" <Chen@.discussions.microsoft.com> wrote in message
news:15706083-2F97-4811-B33A-4A1D6547A159@.microsoft.com...
> Hi,
> Does anyone know that without the tool, how to compare table's layout
> those
> are existing development and production servers?
> Regards,
> -Chen
|||Thank you very much!
"Hari Prasad" wrote:

> Hi,
> You could use INFORMATION_SCHEMA.COLUMNS Views.Put the contents into a table
> and compare.
> SQLCompare from Redgate software has got a very good tool for data and
> schema comparison.
> http://www.red-gate.com/sql_tools.htm
>
> Thanks
> Hari
> SQL Server MVP
>
> "Chen" <Chen@.discussions.microsoft.com> wrote in message
> news:15706083-2F97-4811-B33A-4A1D6547A159@.microsoft.com...
>
>