When it is installed you can simply right-click on a database inside Visual Studio or Visual Web Developer and walkthrough a wizard to script it out: SQL script file capable of re-creating your database (including the schema, sprocs, and actual data content). The SQL Server Hosting Toolkit is a free download that makes it super easy to create a. SQL file to a Hoster and Execute it to Deploy a SQL Database
You can read about what it offers and how to use it in these previous two blog posts of mine: A few months ago I posted about the new SQL Server Database Publishing Hosting Toolkit built and published by the SQL Server team.
