Can I get your recommendations on the best schema differencing tool to be
had?

TIA!

Robert

SQL Compare 4.0.  By far.
http://www.red-gate.com/



Show quoteHide quote

I second that recommendation

Show quoteHide quote

If you are willing to use a Java-based tool in your environment, you
can use SchemaCrawler, a free open-source tool that can compare schemas
as well as data. SchemaCrawler is a command-line tool to output your
database schema and data in a readable form. The output is designed to
be diff-ed with previous versions of your database schema.

http://schemacrawler.sourceforge.net/

All you will need is a JDBC driver, and any diff tool such as WinMerge.

Sualeh Fatehi.

SQL script, split digits and letters
Concatenating:www.aspfaq.com/show.asp?id=2529 Is the glass half full or half empty or..?
CLR Triggers and inserted table
wtf - sorting table doesnt work????
Query Help - Counting Dates and Times
Guaranteed consecutive identity values
Removing duplicate data
Select query
Need help setting up linked server
Switch between TRANSACTIONS