Visual Studio lets you include Microsoft SQL Server database resources in a Web package or when using the Web Publish and One-Click Publish features. By providing the connection string of your source database, Visual Studio automatically creates scripts to re-create the schema and data of the database resources and includes them in the Web package. You can also include custom SQL Server (.sql) scripts and indicate in what sequence the scripts should be run. Once the scripts are included in the package, you can deploy the Web package to any server and re-create the database resources by providing a destination connection string.

For more information about including a SQL Server database in a Web package, see Walkthrough: Deploying a Database with a Web Package. For more information about Web publishing a Web application, see One-Click Publish Overview.