Интерфейс 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 обеспечивает доступ к следующим элементам.
Свойства
| Имя | Описание | |
|---|---|---|
.gif "Открытое свойство") |
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