ITransferSqlServerObjectsTask-Schnittstelle

Diese API unterstützt die SQL Server 2012-Infrastruktur und ist nicht zur direkten Verwendung im Code bestimmt.

Represents a Transfer SQL Server Objects task.

Namespace:  Microsoft.SqlServer.Dts.Tasks.TransferSqlServerObjectsTask
Assembly:  Microsoft.SqlServer.TransferSqlServerObjectsTask (in Microsoft.SqlServer.TransferSqlServerObjectsTask.dll)

Syntax

'Declaration
Public Interface ITransferSqlServerObjectsTask
'Usage
Dim instance As ITransferSqlServerObjectsTask

public interface ITransferSqlServerObjectsTask

public interface class ITransferSqlServerObjectsTask

type ITransferSqlServerObjectsTask =  interface end

public interface ITransferSqlServerObjectsTask

Der ITransferSqlServerObjectsTask-Typ macht folgende Elemente verfügbar.

Eigenschaften

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

Zum Anfang

Siehe auch

Verweis

Microsoft.SqlServer.Dts.Tasks.TransferSqlServerObjectsTask-Namespace