Export (0) Print
Expand All

Generate and Publish Scripts Wizard (Advanced Publishing Options Page)

SQL Server 2008 R2

Use this page to specify how you want this wizard to generate scripts to send to a Web hosting service for publishing. Many different options are available.

NoteNote

To publish, you must have access to a Web service that was installed by using the SQL Server Database Publishing Services. For more information, see the SQL Server Database Publishing Services download page.

Specify advanced options by selecting from the available settings in the list to the right of each option.

General

Convert UDDTs to base types

When True, user-defined data types (UDDT) are converted into the underlying base data types that were used to create them. Use True when the UDDT does not exist in the database where the script will be run. When False, UDDTs are used. The default is False.

Publish collation

Includes collation information for table columns. The default is False. For more information, see Working with Collations.

Publish defaults

Includes default objects used to set default values in table columns. The default is True. For more information, see CREATE DEFAULT (Transact-SQL).

Publish dependent objects

Publishes any object that is required to be present when the script for the selected object is executed. The default is True.

Publish extended properties

Includes extended properties in the script that is sent to the provider for publishing, if the object has extended properties. The default is True. For more information, see Using Extended Properties on Database Objects.

Publish for server version

Creates a script that is sent to the remote provider for publishing in a way that can be run on the selected version of SQL Server. Features new to a version cannot be scripted for earlier versions. The default is the version of the origin server.

Publish object-Level permissions

Includes the permissions on the selected objects in the database. The default is False.

Publish statistics

When set to Publish Statistics, includes the CREATE STATISTICS statement to re-create statistics on the object. The Publish statistics and histograms option also creates histogram information. The default is Do not publish statistics. For more information, see CREATE STATISTICS (Transact-SQL).

Publish vardecimal options

Enables the vardecimal table format on the target database table when it is enabled on the origin database table. The default is True. For more information, see Storing Decimal Data As Variable Length.

Schema qualify object names

Includes the schema name in the name of objects that are created. The default is True.

Script binding

Includes binding for default and rule objects in the script sent to the provider for publishing. The default is True. For more information, see CREATE DEFAULT (Transact-SQL) and CREATE RULE (Transact-SQL).

Types of data to publish

Selects what should be scripted: Data only, Schema Only, or both. The default is Schema and Data.

Publishing Options

Publish using transaction

Uses transactions when publishing to a remote Web hosting provider. If the target database cannot complete the publishing, the transactions are rolled back. The default is True.

Table/View Options

The following options apply only to scripts for tables or views.

Publish check constraints

Includes the creation of CHECK constraints in the publishing process. The default is True. CHECK constraints require data that is entered into a table to meet some specified condition. For more information, see CHECK Constraints.

Publish foreign keys

Includes the creation of foreign keys in the publishing process. The default is True. Foreign keys indicate and enforce relationships between tables. For more information, see FOREIGN KEY Constraints.

Publish full-text indexes

Scripts the creation of full-text indexes. The default is False.

Publish indexes

Includes indexes on tables in the publishing process. The default is True. Indexes help you find data quickly.

Publish primary keys

Includes the creation of primary keys in the publishing process. The default is True. Primary keys uniquely identify each row of a table. For more information, see PRIMARY KEY Constraints.

Publish triggers

Includes the creation of DML triggers in the publishing process. The default is True. A DML trigger is an action programmed to execute when a data manipulation language (DML) event occurs in the database server. For more information, see Understanding DML Triggers.

Publish unique keys

Includes the creation of unique keys on tables in the publishing process. Unique keys prevent duplicate data from being entered. The default is True. For more information, see UNIQUE Constraints.

Publish change tracking

Includes change tracking in the publishing process, if it is enabled on the origin database or tables in the origin database. The default is False. For more information, see Change Tracking Overview.

Publish data compression options

Includes data compression options in the publishing process, if they are configured on the origin database or tables in the origin database. The default is True. For more information, see Creating Compressed Tables and Indexes.

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

Community Additions

ADD
Show:
© 2014 Microsoft