Earlier today CTP6 of the Visual Studio Team Edition for Database Professionals was made available for free download.
VS for Database Professionals has been getting rave reviews, and includes support for database refactorings, schema and data comparisons, database unit testing, and automated data generation. You can learn more about it on its MSDN dev-center and Community page. You can also watch a nice Channel9 video with the team here.
Two other data management tools that I've seen posted on http://weblogs.asp.net recently that look very cool and are worth spending time to check out include:
MassDataHandler - A free CodePlex project that provides a utility library to help automate data generation for unit testing (it can be used within any unit test framework).
Data Dictionary Creator -- A free tool that helps you document SQL Server databases, and helps you keep your documentation in sync with schema changes.
Hope this helps,