I mentioned a
few weeks ago about how I like the ReSharper utility. Another set of
utilities that I've been provided is several of Red Gate's SQL tools. While
I've only been using these tools for several weeks, I've found that these tools
are indispensable for working with SQL Server databases. It's
extremely simple to compare a local database with a remote database to ensure
that the databases (schema and data) are synchronized. Using these tools,
specifically SQL Data
Compare, it's also extremely simple to compare the data in one database with
the data in another to ensure that the appropriate data is in the appropriate
place. Highly recommended!