Objects Supported by the Generate Scripts Wizard

The Generate and Publish Scripts wizard supports a subset of the objects supported by the SQL Server Database Engine.

Supported Objects

The following table lists the objects that can be published and the versions of SQL Server on which they are supported by the Generate and Publish Scripts Wizard.

Database object

SQL Server 2012

SQL Server 2008 R2

SQL Server 2008

SQL Server 2005

Application role

Yes

Yes

Yes

Yes

Assembly

Yes

Yes

Yes

Yes

CHECK constraint

Yes

Yes

Yes

Yes

CLR (common language runtime) stored procedure1

Yes

Yes

Yes

Yes

CLR user-defined function

Yes

Yes

Yes

Yes

Database role

Yes

Yes

Yes

Yes

DEFAULT constraint

Yes

Yes

Yes

Yes

Full-text catalog

Yes

Yes

Yes

Yes

Index

Yes

Yes

Yes

Yes

Rule

Yes

Yes

Yes

Yes

Schema

Yes

Yes

Yes

Yes

Stored procedure1

Yes

Yes

Yes

Yes

Synonym

Yes

Yes

Yes

Yes

Table

Yes

Yes

Yes

Yes

User2

Yes

Yes

Yes

Yes

User-defined aggregate

Yes

Yes

Yes

Yes

User-defined data type

Yes

Yes

Yes

Yes

User-defined function

Yes

Yes

Yes

Yes

User-defined table

Yes

Yes

Yes

No

User-defined type

Yes

Yes

Yes

Yes

View1

Yes

Yes

Yes

Yes

XML schema collection

Yes

Yes

Yes

Yes

1 Published without encryption.

2 Any non-system users that exist in the database are published as Roles.