VS 2010 allows you to optionally deploy a database, along
with your web application files, when are using the “Web Deploy” option as your
deployment mechanism. Databases deployed this way can include both schema and
data, and can optionally also include change scripts to update existing
databases.
ASP.NET Web Projects in VS 2010 have a special page within
their the “project properties” settings to configure database deployments:

I will dive deeper into how to perform database deployments
in future blog posts.