What's New in Visual Database Tools
You can use Visual Database Tools to help create databases, maintain databases, and design the data manipulation portions of your database applications in Visual Studio.
By using Visual Studio 2010, you can create an offline representation of your database. There are three types of this offline representation: database projects, server projects, and Data-tier Application projects. You make changes to the offline representation of your database, and then deploy that project to a target database. By doing this, you can manage changes to your database in much the same way as you manage changes to application code. For more information, see Creating and Managing Databases and Data-tier Applications in Visual Studio.