Export (0) Print
Expand All

Generate and Publish Scripts Wizard (Set Scripting Options Page)

SQL Server 2008 R2

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.

NoteNote

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.

Advanced

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.

Manage Providers

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.

Advanced

Select advanced options that are available for publishing objects to a Web service.

Provider

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.

Target database

Select the target database where you want to publish the objects that you selected.

You must select a provider before selecting a target database.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft