Generate and Publish Scripts Wizard (Set Scripting Options Page)
Use this page to specify if you want the wizard to save scripts to the location of your choice or to use them to publish database objects to a remote Web hosting provider.
To publish, you must have access to a Web service installed by using the Database Publishing Services Web service. For more information, see the Database Publishing Services download page.
If you want the wizard to save scripts to a location of your choice, select Save scripts to a specific location. You can later run the scripts against either an instance of the Database Engine, or against SQL Azure.
If you want the wizard to publish your database objects to a remote Web hosting provider, select Publish to Web service.
Save Scripts to a Specific Location Option
Save scripts to a specific location
Save scripts to a specific location.
Select advanced options that are available for generating scripts.
Save to file
Save the script to one or more .sql files. Click the browse button (…) to specify a name and location for the file. Select the Overwrite existing file check box to replace the file if one already exists with the same name. Click Single file or Single file per object to specify how the scripts should be generated. Click Unicode text or ANSI text to specify the kind of text that should be used in the script.
Save to Clipboard
Save the Transact-SQL script to the Clipboard.
Save to new query window
Generate the script to a Query Editor window. If no editor window is open, a new editor window is opened as the target for the script.
Publish to a Web Service Option
Publish to Web Service
Publish the objects that you selected to a remote Web hosting service for which you have configured a provider.
Display the Manage Providers dialog box. Use the Manage Providers dialog box to add, edit, and delete hosting providers. Each provider specifies the connection information to a Web hosting service and the target databases on that service.
Select advanced options that are available for publishing objects to a Web service.
Select the provider that specifies the connection information for the Web hosting service that hosts the database where you want to publish the objects that you selected.
You must have at least one provider in the Manage Providers dialog box to select a provider.
Select the target database where you want to publish the objects that you selected.
You must select a provider before selecting a target database.