TransferSqlServerObjectsTask.CopyAllObjects Property

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.

Espace de noms: Microsoft.SqlServer.Dts.Tasks.TransferSqlServerObjectsTask
Assembly: Microsoft.SqlServer.TransferSqlServerObjectsTask (in microsoft.sqlserver.transfersqlserverobjectstask.dll)

Syntaxe

'Déclaration
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)

Valeur de propriété

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

Notes

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

Sécurité des threads

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.

Plateformes

Plateformes de développement

Pour obtenir la liste des plateformes prises en charge, consultez Configuration matérielle et logicielle requise pour l'installation de SQL Server 2005.

Plateformes cibles

Pour obtenir la liste des plateformes prises en charge, consultez Configuration matérielle et logicielle requise pour l'installation de SQL Server 2005.

Voir aussi

Référence

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