Interfaz ITransferSqlServerObjectsTask

Esta API admite la infraestructura de SQL Server 2012 y no está prevista su utilización directa desde el código.

Represents a Transfer SQL Server Objects task.

Espacio de nombres:  Microsoft.SqlServer.Dts.Tasks.TransferSqlServerObjectsTask
Ensamblado:  Microsoft.SqlServer.TransferSqlServerObjectsTask (en Microsoft.SqlServer.TransferSqlServerObjectsTask.dll)

Sintaxis

'Declaración
Public Interface ITransferSqlServerObjectsTask
'Uso
Dim instance As ITransferSqlServerObjectsTask

public interface ITransferSqlServerObjectsTask

public interface class ITransferSqlServerObjectsTask

type ITransferSqlServerObjectsTask =  interface end

public interface ITransferSqlServerObjectsTask

El tipo ITransferSqlServerObjectsTask expone los siguientes miembros.

Propiedades

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

Arriba

Vea también

Referencia

Espacio de nombres Microsoft.SqlServer.Dts.Tasks.TransferSqlServerObjectsTask