TransferSqlServerObjectsTask.CopyAllObjects Property

Reference

Definition

Namespace:: Microsoft.SqlServer.Dts.Tasks.TransferSqlServerObjectsTask

Assembly:: Microsoft.SqlServer.TransferSqlServerObjectsTask.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

Gets or sets a Boolean indicating whether all SQL Server database objects are transferred from the source to the target database, or only the specified objects. The following SQL Server database objects can be transferred: defaults, rules, stored procedures, tables, triggers, user-defined data types, and views.

public:
 property bool CopyAllObjects { bool get(); void set(bool value); };

public bool CopyAllObjects { get; set; }

member this.CopyAllObjects : bool with get, set

Public Property CopyAllObjects As Boolean

Property Value

Boolean

true indicates that all the SQL Server database objects of the specified type are transferred from the source to the target database.

Implements

CopyAllObjects

Remarks

The default value is true, indicating that the following objects are transferred:

Logins
Users
Rules
Tables
Views
Stored Procedures
User Defined Functions
Defaults
User Defined Data Types

The following objects are also transferred. These objects are only found in Microsoft SQL Server 2005 or later versions:

Partition Functions
Partition Schemes
Schemas
SQL Assemblies
User Defined Aggregates
User Defined Types
Xml Schema Collections

Applies to