Generate and Publish Scripts Wizard (Advanced Publishing Options Page)

• 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.

• 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.

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.