Interface ITransferSqlServerObjectsTask
Essa API oferece suporte à infraestrutura do SQL Server 2012 e não se destina a ser usada diretamente no seu código.
Represents a Transfer SQL Server Objects task.
Namespace: Microsoft.SqlServer.Dts.Tasks.TransferSqlServerObjectsTask
Assembly: Microsoft.SqlServer.TransferSqlServerObjectsTask (em Microsoft.SqlServer.TransferSqlServerObjectsTask.dll)
Sintaxe
'Declaração
Public Interface ITransferSqlServerObjectsTask
'Uso
Dim instance As ITransferSqlServerObjectsTask
public interface ITransferSqlServerObjectsTask
public interface class ITransferSqlServerObjectsTask
type ITransferSqlServerObjectsTask = interface end
public interface ITransferSqlServerObjectsTask
O tipo ITransferSqlServerObjectsTask expõe os membros a seguir.
Propriedades
Nome | Descrição | |
---|---|---|
CopyAllDefaults | Infraestrutura. Gets or sets a value that indicates whether the transfer includes the SQL Server defaults. | |
CopyAllLogins | Infraestrutura. Gets or sets a value that indicates whether all the SQL Server logins are copied from the source database to the target database. | |
CopyAllObjects | Infraestrutura. 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 | Infraestrutura. Gets or sets a value that indicates whether all SQL Server partitions are transferred from the source to the target database. | |
CopyAllPartitionSchemes | Infraestrutura. Gets or sets a value that indicates whether all SQL Server partition schemes are transferred from the source to the target database. | |
CopyAllRules | Infraestrutura. Gets or sets a value that indicates whether all SQL Server rules are transferred from the source to the target database. | |
CopyAllSchemas | Infraestrutura. Gets or sets a value that indicates whether all SQL Server schemas are transferred from the source to the target database. | |
CopyAllSqlAssemblies | Infraestrutura. Gets or sets a value that indicates whether all SQL Server assemblies are transferred from the source to the target database. | |
CopyAllStoredProcedures | Infraestrutura. Gets or sets a value that indicates whether all SQL Server stored procedures are transferred from the source to the target database. | |
CopyAllTables | Infraestrutura. Gets or sets a value that indicates whether all SQL Server tables are transferred from the source to the target database. | |
CopyAllUserDefinedAggregates | Infraestrutura. Gets or sets a value that indicates whether all user-defined aggregates are transferred from the source to the target database. | |
CopyAllUserDefinedDataTypes | Infraestrutura. Gets or sets a value that indicates whether all user-defined data types are transferred from the source to the target database. | |
CopyAllUserDefinedFunctions | Infraestrutura. Gets or sets a value that indicates whether all user-defined functions are transferred from the source to the target database. | |
CopyAllUserDefinedTypes | Infraestrutura. Gets or sets a value that indicates whether all user-defined types are transferred from the source to the target database. | |
CopyAllUsers | Infraestrutura. 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 | Infraestrutura. Gets or sets a value that indicates whether all SQL Server views are transferred from the source to the target database. | |
CopyAllXmlSchemaCollections | Infraestrutura. Gets or sets a value that indicates whether all XML schema collections are transferred from the source to the target database. | |
CopyData | Infraestrutura. Gets or sets a value that indicates whether the data is transferred from the SQL Server source to the target database. | |
CopyDatabaseRoles | Infraestrutura. Gets or sets a value that indicates whether database roles are transferred from the source to the target database. | |
CopyDatabaseUsers | Infraestrutura. Gets or sets a value that indicates whether database users are transferred from the source to the target database. | |
CopyForeignKeys | Infraestrutura. Gets or sets a value that indicates whether foreign keys are transferred from the source to the target database. | |
CopyFullTextIndexes | Infraestrutura. Gets or sets a value that indicates whether full-text properties are transferred from the source to the target database. | |
CopyIndexes | Infraestrutura. Gets or sets a value that indicates whether indexes are transferred from the source to the target database. | |
CopyObjectLevelPermissions | Infraestrutura. Gets or sets a value that indicates whether securable objects are included in the transfer from the source to the target database. | |
CopyPrimaryKeys | Infraestrutura. Gets or sets a value that indicates whether primary keys are transferred from the source to the target database. | |
CopySchema | Infraestrutura. Gets or sets a value that indicates whether the schema is copied from the source database to the target database. | |
CopySqlServerLogins | Infraestrutura. Gets or sets a value that indicates whether SQL Server logins are included in the transfer from the source to the target database. | |
CopyTriggers | Infraestrutura. Gets or sets a value that indicates whether triggers are transferred from the source to the target database. | |
DefaultsList | Infraestrutura. Gets or sets the default objects to transfer. | |
DestinationConnection | Infraestrutura. Gets or sets the name of the destination connection. | |
DestinationDatabase | Infraestrutura. Gets or sets the name of the destination database. | |
DestinationTranslateChar | Infraestrutura. Gets or sets a value that indicates whether the character data is translated from the destination database. | |
DropObjectsFirst | Infraestrutura. Gets or sets a value that indicates whether objects at the destination are dropped before copying is started. | |
ExistingData | Infraestrutura. Gets or sets a value from the ExistingData enumeration to determine whether data should be appended to existing data. | |
GenerateScriptsInUnicode | Infraestrutura. Gets or sets a value that indicates whether the script generated is in Unicode format. | |
IncludeDependentObjects | Infraestrutura. Gets or sets a value that indicates whether the dependent objects are included in the transfer. | |
IncludeExtendedProperties | Infraestrutura. Gets or sets a value that indicates whether extended properties are transferred from the source to the target database. | |
LoginsList | Infraestrutura. Gets or sets the list of logins to transfer. | |
PartitionFunctionsList | Infraestrutura. Gets or sets the list of partition functions to transfer. | |
PartitionSchemesList | Infraestrutura. Gets or sets the list of partition schemes to transfer. | |
RulesList | Infraestrutura. Gets or sets the list of rules to transfer. | |
SchemasList | Infraestrutura. Gets or sets the list of schemas to transfer. | |
SourceConnection | Infraestrutura. Gets or sets the name of the connection manager for the source database. | |
SourceDatabase | Infraestrutura. Gets or sets the name of the database from which objects will be transferred. | |
SourceTranslateChar | Infraestrutura. Gets or sets a value that indicates whether the character data is translated from the source database. | |
SqlAssembliesList | Infraestrutura. Gets or sets the list of SQL Server assemblies to transfer. | |
StoredProceduresList | Infraestrutura. Gets or sets the list of stored procedures to transfer. | |
TablesList | Infraestrutura. Gets or sets the list of tables to transfer. | |
UseCollation | Infraestrutura. Gets or sets a value that indicates whether the transfer should use collations. | |
UserDefinedAggregatesList | Infraestrutura. Gets or sets a list of user-defined aggregates to transfer. | |
UserDefinedDataTypesList | Infraestrutura. Gets or sets the list of user-defined data types to transfer. | |
UserDefinedFunctionsList | Infraestrutura. Gets or sets a list of user-defined functions to transfer. | |
UserDefinedTypesList | Infraestrutura. Gets or sets a list of user-defined types to transfer. | |
UsersList | Infraestrutura. Gets or sets a list of users to transfer. | |
ViewsList | Infraestrutura. Gets or sets a list of views to transfer. | |
XmlSchemaCollectionsList | Infraestrutura. Gets or sets a list of XML schema collections to transfer. |
Início
Consulte também
Referência
Namespace Microsoft.SqlServer.Dts.Tasks.TransferSqlServerObjectsTask