Condividi tramite

  • Articolo

Proprietà CopyAllObjects

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.

Spazio dei nomi  Microsoft.SqlServer.Dts.Tasks.TransferSqlServerObjectsTask
Assembly:  Microsoft.SqlServer.TransferSqlServerObjectsTask (in Microsoft.SqlServer.TransferSqlServerObjectsTask.dll)

Sintassi

'Dichiarazione
Public Property CopyAllObjects As Boolean
    Get
    Set
'Utilizzo
Dim instance As TransferSqlServerObjectsTask
Dim value As Boolean

value = instance.CopyAllObjects

instance.CopyAllObjects = value

public bool CopyAllObjects { get; set; }

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

abstract CopyAllObjects : bool with get, set
override CopyAllObjects : bool with get, set

final function get CopyAllObjects () : boolean
final function set CopyAllObjects (value : boolean)

Valore proprietà

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

Implementa

ITransferSqlServerObjectsTask. . :: . .CopyAllObjects

Osservazioni

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