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 命名空间