Partager via

Interface ITransferSqlServerObjectsTask

Cette API prend en charge l'infrastructure SQL Server 2012 et n'est pas destinée à être utilisée directement à partir de votre code.

Represents a Transfer SQL Server Objects task.

Espace de noms :  Microsoft.SqlServer.Dts.Tasks.TransferSqlServerObjectsTask
Assembly :  Microsoft.SqlServer.TransferSqlServerObjectsTask (en Microsoft.SqlServer.TransferSqlServerObjectsTask.dll)

Syntaxe

'Déclaration
Public Interface ITransferSqlServerObjectsTask
'Utilisation
Dim instance As ITransferSqlServerObjectsTask

public interface ITransferSqlServerObjectsTask

public interface class ITransferSqlServerObjectsTask

type ITransferSqlServerObjectsTask =  interface end

public interface ITransferSqlServerObjectsTask

Le type ITransferSqlServerObjectsTask expose les membres suivants.

Propriétés

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

Haut de la page

Voir aussi

Référence

Espace de noms Microsoft.SqlServer.Dts.Tasks.TransferSqlServerObjectsTask

  • Last updated on