|
Home > Archive > MS SQL Server > May 2005 > Compare tables layout in dev and prod
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 |
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
| |
| Hari Prasad 2005-05-20, 8:23 pm |
| 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@microso
ft.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@microso
ft.com...
>
>
>
|
|
|
|
|