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
Check Constraint
Database Role
Default Constraint
Extended Properties
Full-text Catalog
Full-text Index
Stored Procedure Without Encryption Only
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 11:54 PM by alexd, version 29


No comments yet.