Red Gate has a lovely suite of tools to work with SQL databases. Their bundle has a SQL compare tools to compare the structure of a database as well as the content. The tools not only show the differences but also generate sql scripts to update structure or content. Previously I blogged on my experiences with SQL compare. A search for Red-Gate on CB will show that many of us have good experiences. The tools have really saved us loads and loads of work. The previous version works pretty well with SQL 2005. And now there is a whole new version out: SQL bundle 5.

The first thing which meets the eye is the completely revised UI. The former was the only point which could use some polishing. Their new one is great:

It still does have its idiosyncrasies. FI the way to close the interactive help is different but intuitive. But the amount and overview of the information is overwhelming and really pleases my widescreen.

Download the trial at your own risk, it's addicting software :)