I have been waiting anxiously for this: Microsoft has announced Team System for Database Professionals. Among the coming features are:

  • rename refactoring,
  • a new T-SQL editor,
  • a schema compare tool that will generate scripts to sync the schemas of two databases,
  • a data compare tool that will generate scripts to sync the data in two databases, and
  • a database unit testing infrastructure.

More info here: http://msdn.microsoft.com/vstudio/teamsystem/products/dbpro/default.aspx