TransferSqlServerObjectsTask.CopyAllObjects Property

아티클
12/15/2008

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.

네임스페이스: Microsoft.SqlServer.Dts.Tasks.TransferSqlServerObjectsTask
어셈블리: Microsoft.SqlServer.TransferSqlServerObjectsTask (in microsoft.sqlserver.transfersqlserverobjectstask.dll)

구문

‘선언
Public Property CopyAllObjects As Boolean

public bool CopyAllObjects { get; set; }

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

/** @property */
public final boolean get_CopyAllObjects ()

/** @property */
public final void set_CopyAllObjects (boolean value)

public final function get CopyAllObjects () : boolean

public final function set CopyAllObjects (value : boolean)

속성 값

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

주의

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:

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

스레드 보안

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

플랫폼

개발 플랫폼

지원되는 플랫폼 목록은 SQL Server 2005 설치를 위한 하드웨어 및 소프트웨어 요구 사항을 참조하십시오.

대상 플랫폼

지원되는 플랫폼 목록은 SQL Server 2005 설치를 위한 하드웨어 및 소프트웨어 요구 사항을 참조하십시오.

참고 항목

참조

TransferSqlServerObjectsTask Class
TransferSqlServerObjectsTask Members
Microsoft.SqlServer.Dts.Tasks.TransferSqlServerObjectsTask Namespace

다음을 통해 공유