Comparing Table Structures

Or, he could just use DMO if he doesn't want that investment.

James Hokes

"David Satz" <davidNOSPAMsatz@yahoo.NOSPAM.com> wrote in message
news:3db00edb$1@tnews.web.dev-archive.com...
> there are several products that do this for SQL server - see
> http://www.mssqlserver.com/products/ but SQL Compare
> (http://www.mssqlserver.com/products/sqlcompare101_p1.asp) is exactly what
> you are looking for.
>
>
> --
> HTH,
> David Satz
> Principal Web Engineer
> Hyperion Solutions
>
> "Mark" <mark_yachnin@alarmnet.com> wrote in message
> news:3daee06c$1@tnews.web.dev-archive.com...
> >
> > How can I compare the table structures of TestServer.tblX with
> ProductionServer.tblX?
> >
> > Is there any SQL trick or System Stored Procedure I can use?
> >
> > I'd also like to compare all their indexes, keys, constraints, etc.
> >
> > Thanks for your help!
>
>