Publish a Database (SQL Server Management Studio)
You can use the Generate and Publish Scripts Wizard to publish an entire database or individual database objects to a Web hosting provider.
The functionality described in this topic used to be provided by the Publish Database Wizard. The publishing functionality has been added to the Generate and Publish Scripts Wizard, and the Publish Database Wizard has been discontinued.
The Generate and Publish Scripts Wizard can be used to publish a database or selected database objects to a Web hosting provider. A SQL Server Web hosting provider is a connectivity interface to a Web service. The Web service is created by using the Database Publishing Services project from the SQL Server Hosting Toolkit on CodePlex. The Web service makes it easy for the Web hoster customers to publish their databases to the service by using the Generate and Publish Scripts Wizard. For more information about downloading the SQL Server Hosting Toolkit, see SQL Server Database Publishing Services.
The Generate and Publish Scripts Wizard can also be used to create a script for transferring a database.
To publish a database to a Web service
In Object Explorer, expand Databases, right-click a database, point to Tasks, and then click Generate and Publish Scripts. Follow the steps in the wizard to script the database objects for publishing.
On the Choose Objects page, select the objects to be published to the Web hosting service.
On the Set Scripting Options page, select Publish to Web Service.
In the Provider box, specify the provider for your Web service. If you have not configured a Web hosting provider, select Manage Providers and use the Manage Providers dialog box to configure a provider for your Web service.
To specify advanced publishing options, select the Advanced button in the Publish to Web Service section.
On the Summary page, review your selections. Click Previous to change your selections. Click Next to publish the objects you selected.
On the Save or Publish Scripts page, monitor the progress of the publication.