Export (0) Print
Expand All

ITransferSqlServerObjectsTask Interface

This API supports the SQL Server 2012 infrastructure and is not intended to be used directly from your code.

Represents a Transfer SQL Server Objects task.

Namespace:  Microsoft.SqlServer.Dts.Tasks.TransferSqlServerObjectsTask
Assembly:  Microsoft.SqlServer.TransferSqlServerObjectsTask (in Microsoft.SqlServer.TransferSqlServerObjectsTask.dll)

type ITransferSqlServerObjectsTask =  interface end

The ITransferSqlServerObjectsTask type exposes the following members.

  NameDescription
Public propertyCopyAllDefaultsInfrastructure. Gets or sets a value that indicates whether the transfer includes the SQL Server defaults.
Public propertyCopyAllLoginsInfrastructure. Gets or sets a value that indicates whether all the SQL Server logins are copied from the source database to the target database.
Public propertyCopyAllObjectsInfrastructure. 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.
Public propertyCopyAllPartitionFunctionsInfrastructure. Gets or sets a value that indicates whether all SQL Server partitions are transferred from the source to the target database.
Public propertyCopyAllPartitionSchemesInfrastructure. Gets or sets a value that indicates whether all SQL Server partition schemes are transferred from the source to the target database.
Public propertyCopyAllRulesInfrastructure. Gets or sets a value that indicates whether all SQL Server rules are transferred from the source to the target database.
Public propertyCopyAllSchemasInfrastructure. Gets or sets a value that indicates whether all SQL Server schemas are transferred from the source to the target database.
Public propertyCopyAllSqlAssembliesInfrastructure. Gets or sets a value that indicates whether all SQL Server assemblies are transferred from the source to the target database.
Public propertyCopyAllStoredProceduresInfrastructure. Gets or sets a value that indicates whether all SQL Server stored procedures are transferred from the source to the target database.
Public propertyCopyAllTablesInfrastructure. Gets or sets a value that indicates whether all SQL Server tables are transferred from the source to the target database.
Public propertyCopyAllUserDefinedAggregatesInfrastructure. Gets or sets a value that indicates whether all user-defined aggregates are transferred from the source to the target database.
Public propertyCopyAllUserDefinedDataTypesInfrastructure. Gets or sets a value that indicates whether all user-defined data types are transferred from the source to the target database.
Public propertyCopyAllUserDefinedFunctionsInfrastructure. Gets or sets a value that indicates whether all user-defined functions are transferred from the source to the target database.
Public propertyCopyAllUserDefinedTypesInfrastructure. Gets or sets a value that indicates whether all user-defined types are transferred from the source to the target database.
Public propertyCopyAllUsersInfrastructure. Gets or sets a value that indicates whether all the SQL Server database users are copied from the source database to the target database.
Public propertyCopyAllViewsInfrastructure. Gets or sets a value that indicates whether all SQL Server views are transferred from the source to the target database.
Public propertyCopyAllXmlSchemaCollectionsInfrastructure. Gets or sets a value that indicates whether all XML schema collections are transferred from the source to the target database.
Public propertyCopyDataInfrastructure. Gets or sets a value that indicates whether the data is transferred from the SQL Server source to the target database.
Public propertyCopyDatabaseRolesInfrastructure. Gets or sets a value that indicates whether database roles are transferred from the source to the target database.
Public propertyCopyDatabaseUsersInfrastructure. Gets or sets a value that indicates whether database users are transferred from the source to the target database.
Public propertyCopyForeignKeysInfrastructure. Gets or sets a value that indicates whether foreign keys are transferred from the source to the target database.
Public propertyCopyFullTextIndexesInfrastructure. Gets or sets a value that indicates whether full-text properties are transferred from the source to the target database.
Public propertyCopyIndexesInfrastructure. Gets or sets a value that indicates whether indexes are transferred from the source to the target database.
Public propertyCopyObjectLevelPermissionsInfrastructure. Gets or sets a value that indicates whether securable objects are included in the transfer from the source to the target database.
Public propertyCopyPrimaryKeysInfrastructure. Gets or sets a value that indicates whether primary keys are transferred from the source to the target database.
Public propertyCopySchemaInfrastructure. Gets or sets a value that indicates whether the schema is copied from the source database to the target database.
Public propertyCopySqlServerLoginsInfrastructure. Gets or sets a value that indicates whether SQL Server logins are included in the transfer from the source to the target database.
Public propertyCopyTriggersInfrastructure. Gets or sets a value that indicates whether triggers are transferred from the source to the target database.
Public propertyDefaultsListInfrastructure. Gets or sets the default objects to transfer.
Public propertyDestinationConnectionInfrastructure. Gets or sets the name of the destination connection.
Public propertyDestinationDatabaseInfrastructure. Gets or sets the name of the destination database.
Public propertyDestinationTranslateCharInfrastructure. Gets or sets a value that indicates whether the character data is translated from the destination database.
Public propertyDropObjectsFirstInfrastructure. Gets or sets a value that indicates whether objects at the destination are dropped before copying is started.
Public propertyExistingDataInfrastructure. Gets or sets a value from the ExistingData enumeration to determine whether data should be appended to existing data.
Public propertyGenerateScriptsInUnicodeInfrastructure. Gets or sets a value that indicates whether the script generated is in Unicode format.
Public propertyIncludeDependentObjectsInfrastructure. Gets or sets a value that indicates whether the dependent objects are included in the transfer.
Public propertyIncludeExtendedPropertiesInfrastructure. Gets or sets a value that indicates whether extended properties are transferred from the source to the target database.
Public propertyLoginsListInfrastructure. Gets or sets the list of logins to transfer.
Public propertyPartitionFunctionsListInfrastructure. Gets or sets the list of partition functions to transfer.
Public propertyPartitionSchemesListInfrastructure. Gets or sets the list of partition schemes to transfer.
Public propertyRulesListInfrastructure. Gets or sets the list of rules to transfer.
Public propertySchemasListInfrastructure. Gets or sets the list of schemas to transfer.
Public propertySourceConnectionInfrastructure. Gets or sets the name of the connection manager for the source database.
Public propertySourceDatabaseInfrastructure. Gets or sets the name of the database from which objects will be transferred.
Public propertySourceTranslateCharInfrastructure. Gets or sets a value that indicates whether the character data is translated from the source database.
Public propertySqlAssembliesListInfrastructure. Gets or sets the list of SQL Server assemblies to transfer.
Public propertyStoredProceduresListInfrastructure. Gets or sets the list of stored procedures to transfer.
Public propertyTablesListInfrastructure. Gets or sets the list of tables to transfer.
Public propertyUseCollationInfrastructure. Gets or sets a value that indicates whether the transfer should use collations.
Public propertyUserDefinedAggregatesListInfrastructure. Gets or sets a list of user-defined aggregates to transfer.
Public propertyUserDefinedDataTypesListInfrastructure. Gets or sets the list of user-defined data types to transfer.
Public propertyUserDefinedFunctionsListInfrastructure. Gets or sets a list of user-defined functions to transfer.
Public propertyUserDefinedTypesListInfrastructure. Gets or sets a list of user-defined types to transfer.
Public propertyUsersListInfrastructure. Gets or sets a list of users to transfer.
Public propertyViewsListInfrastructure. Gets or sets a list of views to transfer.
Public propertyXmlSchemaCollectionsListInfrastructure. Gets or sets a list of XML schema collections to transfer.
Top

Community Additions

ADD
Show:
© 2015 Microsoft