Interfaccia ITransferSqlServerObjectsTask

Questa API supporta l'infrastruttura SQL Server 2012 e non può essere utilizzata direttamente dal codice.

Represents a Transfer SQL Server Objects task.

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

Sintassi

'Dichiarazione
Public Interface ITransferSqlServerObjectsTask
'Utilizzo
Dim instance As ITransferSqlServerObjectsTask

public interface ITransferSqlServerObjectsTask

public interface class ITransferSqlServerObjectsTask

type ITransferSqlServerObjectsTask =  interface end

public interface ITransferSqlServerObjectsTask

Nel tipo ITransferSqlServerObjectsTask sono esposti i membri seguenti.

Proprietà

	Nome	Descrizione
	CopyAllDefaults	Infrastruttura. Gets or sets a value that indicates whether the transfer includes the SQL Server defaults.
	CopyAllLogins	Infrastruttura. Gets or sets a value that indicates whether all the SQL Server logins are copied from the source database to the target database.
	CopyAllObjects	Infrastruttura. Gets or sets a value that indicates whether all the SQL database objects of the specified type are transferred from the source to the target database.
	CopyAllPartitionFunctions	Infrastruttura. Gets or sets a value that indicates whether all SQL Server partitions are transferred from the source to the target database.
	CopyAllPartitionSchemes	Infrastruttura. Gets or sets a value that indicates whether all SQL Server partition schemes are transferred from the source to the target database.
	CopyAllRules	Infrastruttura. Gets or sets a value that indicates whether all SQL Server rules are transferred from the source to the target database.
	CopyAllSchemas	Infrastruttura. Gets or sets a value that indicates whether all SQL Server schemas are transferred from the source to the target database.
	CopyAllSqlAssemblies	Infrastruttura. Gets or sets a value that indicates whether all SQL Server assemblies are transferred from the source to the target database.
	CopyAllStoredProcedures	Infrastruttura. Gets or sets a value that indicates whether all SQL Server stored procedures are transferred from the source to the target database.
	CopyAllTables	Infrastruttura. Gets or sets a value that indicates whether all SQL Server tables are transferred from the source to the target database.
	CopyAllUserDefinedAggregates	Infrastruttura. Gets or sets a value that indicates whether all user-defined aggregates are transferred from the source to the target database.
	CopyAllUserDefinedDataTypes	Infrastruttura. Gets or sets a value that indicates whether all user-defined data types are transferred from the source to the target database.
	CopyAllUserDefinedFunctions	Infrastruttura. Gets or sets a value that indicates whether all user-defined functions are transferred from the source to the target database.
	CopyAllUserDefinedTypes	Infrastruttura. Gets or sets a value that indicates whether all user-defined types are transferred from the source to the target database.
	CopyAllUsers	Infrastruttura. Gets or sets a value that indicates whether all the SQL Server database users are copied from the source database to the target database.
	CopyAllViews	Infrastruttura. Gets or sets a value that indicates whether all SQL Server views are transferred from the source to the target database.
	CopyAllXmlSchemaCollections	Infrastruttura. Gets or sets a value that indicates whether all XML schema collections are transferred from the source to the target database.
	CopyData	Infrastruttura. Gets or sets a value that indicates whether the data is transferred from the SQL Server source to the target database.
	CopyDatabaseRoles	Infrastruttura. Gets or sets a value that indicates whether database roles are transferred from the source to the target database.
	CopyDatabaseUsers	Infrastruttura. Gets or sets a value that indicates whether database users are transferred from the source to the target database.
	CopyForeignKeys	Infrastruttura. Gets or sets a value that indicates whether foreign keys are transferred from the source to the target database.
	CopyFullTextIndexes	Infrastruttura. Gets or sets a value that indicates whether full-text properties are transferred from the source to the target database.
	CopyIndexes	Infrastruttura. Gets or sets a value that indicates whether indexes are transferred from the source to the target database.
	CopyObjectLevelPermissions	Infrastruttura. Gets or sets a value that indicates whether securable objects are included in the transfer from the source to the target database.
	CopyPrimaryKeys	Infrastruttura. Gets or sets a value that indicates whether primary keys are transferred from the source to the target database.
	CopySchema	Infrastruttura. Gets or sets a value that indicates whether the schema is copied from the source database to the target database.
	CopySqlServerLogins	Infrastruttura. Gets or sets a value that indicates whether SQL Server logins are included in the transfer from the source to the target database.
	CopyTriggers	Infrastruttura. Gets or sets a value that indicates whether triggers are transferred from the source to the target database.
	DefaultsList	Infrastruttura. Gets or sets the default objects to transfer.
	DestinationConnection	Infrastruttura. Gets or sets the name of the destination connection.
	DestinationDatabase	Infrastruttura. Gets or sets the name of the destination database.
	DestinationTranslateChar	Infrastruttura. Gets or sets a value that indicates whether the character data is translated from the destination database.
	DropObjectsFirst	Infrastruttura. Gets or sets a value that indicates whether objects at the destination are dropped before copying is started.
	ExistingData	Infrastruttura. Gets or sets a value from the ExistingData enumeration to determine whether data should be appended to existing data.
	GenerateScriptsInUnicode	Infrastruttura. Gets or sets a value that indicates whether the script generated is in Unicode format.
	IncludeDependentObjects	Infrastruttura. Gets or sets a value that indicates whether the dependent objects are included in the transfer.
	IncludeExtendedProperties	Infrastruttura. Gets or sets a value that indicates whether extended properties are transferred from the source to the target database.
	LoginsList	Infrastruttura. Gets or sets the list of logins to transfer.
	PartitionFunctionsList	Infrastruttura. Gets or sets the list of partition functions to transfer.
	PartitionSchemesList	Infrastruttura. Gets or sets the list of partition schemes to transfer.
	RulesList	Infrastruttura. Gets or sets the list of rules to transfer.
	SchemasList	Infrastruttura. Gets or sets the list of schemas to transfer.
	SourceConnection	Infrastruttura. Gets or sets the name of the connection manager for the source database.
	SourceDatabase	Infrastruttura. Gets or sets the name of the database from which objects will be transferred.
	SourceTranslateChar	Infrastruttura. Gets or sets a value that indicates whether the character data is translated from the source database.
	SqlAssembliesList	Infrastruttura. Gets or sets the list of SQL Server assemblies to transfer.
	StoredProceduresList	Infrastruttura. Gets or sets the list of stored procedures to transfer.
	TablesList	Infrastruttura. Gets or sets the list of tables to transfer.
	UseCollation	Infrastruttura. Gets or sets a value that indicates whether the transfer should use collations.
	UserDefinedAggregatesList	Infrastruttura. Gets or sets a list of user-defined aggregates to transfer.
	UserDefinedDataTypesList	Infrastruttura. Gets or sets the list of user-defined data types to transfer.
	UserDefinedFunctionsList	Infrastruttura. Gets or sets a list of user-defined functions to transfer.
	UserDefinedTypesList	Infrastruttura. Gets or sets a list of user-defined types to transfer.
	UsersList	Infrastruttura. Gets or sets a list of users to transfer.
	ViewsList	Infrastruttura. Gets or sets a list of views to transfer.
	XmlSchemaCollectionsList	Infrastruttura. Gets or sets a list of XML schema collections to transfer.

In alto

Vedere anche

Riferimento

Spazio dei nomi Microsoft.SqlServer.Dts.Tasks.TransferSqlServerObjectsTask