-
We do not yet have a good way to compare our Test and Production databases. This will be changing very soon. In the meantime, I have written the script below that may be of use for others without database compare tools. You can script all of the stored procedures in a SQL Server 2005 database to a "...
-
Recommended tool for SQL schema and data comparisons to merger dev changes into prod database. http://redgate.com/products/SQL_Compare/index.htm The DB skew of Visual Studio 2005 Team edition is about to be released, which also performs this function.