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.