Scripted Object Types

The Database Publishing Wizard does not script all object types supported by both SQL Server 2000 or SQL Server 2005. All server-level objects are not scripted since scripts are designed to be executed in shared hosting environments

Currently Scripted Object Types Notes
Application roles
Assemblies
Check Constraint
Database Role
Default Constraint
Extended Properties
Full-text Catalog
Full-text Index
Index
Roles
Rule
Stored Procedure Without Encryption Only
Table
Trigger Without Encryption Only
User Any non-system users that exist in the source database will be scripted as roles because shared hosting provider do not typically allow the ability to create additional logins.
User Defined Aggregate
User Defined Data Type
User Defined Function Without Encryption Only
View Without Encryption Only


Supported Data Types

All data types are supported.

Last edited Jan 18, 2007 at 10:54 PM by alexd, version 29

Comments

No comments yet.