ITransferSqlServerObjectsTask 介面

此 API 支援 SQL Server 2012 基礎結構，但無法直接從您的程式碼使用。

Represents a Transfer SQL Server Objects task.

命名空間：  Microsoft.SqlServer.Dts.Tasks.TransferSqlServerObjectsTask
組件：  Microsoft.SqlServer.TransferSqlServerObjectsTask (在 Microsoft.SqlServer.TransferSqlServerObjectsTask.dll 中)

語法

'宣告
Public Interface ITransferSqlServerObjectsTask
'用途
Dim instance As ITransferSqlServerObjectsTask

public interface ITransferSqlServerObjectsTask

public interface class ITransferSqlServerObjectsTask

type ITransferSqlServerObjectsTask =  interface end

public interface ITransferSqlServerObjectsTask

ITransferSqlServerObjectsTask 型別公開下列成員。

屬性

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

上層

請參閱

參考

Microsoft.SqlServer.Dts.Tasks.TransferSqlServerObjectsTask 命名空間