Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

ITransferSqlServerObjectsTask Interface

 

Applies To: SQL Server 2016 Preview

This API supports the product 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)

Public Interface ITransferSqlServerObjectsTask

NameDescription
System_CAPS_pubpropertyCopyAllDefaults

This API supports the product infrastructure and is not intended to be used directly from your code. Gets or sets a value that indicates whether the transfer includes the SQL Server defaults.

System_CAPS_pubpropertyCopyAllLogins

This API supports the product infrastructure and is not intended to be used directly from your code. Gets or sets a value that indicates whether all the SQL Server logins are copied from the source database to the target database.

System_CAPS_pubpropertyCopyAllObjects

This API supports the product infrastructure and is not intended to be used directly from your code. 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.

System_CAPS_pubpropertyCopyAllPartitionFunctions

This API supports the product infrastructure and is not intended to be used directly from your code. Gets or sets a value that indicates whether all SQL Server partitions are transferred from the source to the target database.

System_CAPS_pubpropertyCopyAllPartitionSchemes

This API supports the product infrastructure and is not intended to be used directly from your code. Gets or sets a value that indicates whether all SQL Server partition schemes are transferred from the source to the target database.

System_CAPS_pubpropertyCopyAllRules

This API supports the product infrastructure and is not intended to be used directly from your code. Gets or sets a value that indicates whether all SQL Server rules are transferred from the source to the target database.

System_CAPS_pubpropertyCopyAllSchemas

This API supports the product infrastructure and is not intended to be used directly from your code. Gets or sets a value that indicates whether all SQL Server schemas are transferred from the source to the target database.

System_CAPS_pubpropertyCopyAllSqlAssemblies

This API supports the product infrastructure and is not intended to be used directly from your code. Gets or sets a value that indicates whether all SQL Server assemblies are transferred from the source to the target database.

System_CAPS_pubpropertyCopyAllStoredProcedures

This API supports the product infrastructure and is not intended to be used directly from your code. Gets or sets a value that indicates whether all SQL Server stored procedures are transferred from the source to the target database.

System_CAPS_pubpropertyCopyAllTables

This API supports the product infrastructure and is not intended to be used directly from your code. Gets or sets a value that indicates whether all SQL Server tables are transferred from the source to the target database.

System_CAPS_pubpropertyCopyAllUserDefinedAggregates

This API supports the product infrastructure and is not intended to be used directly from your code. Gets or sets a value that indicates whether all user-defined aggregates are transferred from the source to the target database.

System_CAPS_pubpropertyCopyAllUserDefinedDataTypes

This API supports the product infrastructure and is not intended to be used directly from your code. Gets or sets a value that indicates whether all user-defined data types are transferred from the source to the target database.

System_CAPS_pubpropertyCopyAllUserDefinedFunctions

This API supports the product infrastructure and is not intended to be used directly from your code. Gets or sets a value that indicates whether all user-defined functions are transferred from the source to the target database.

System_CAPS_pubpropertyCopyAllUserDefinedTypes

This API supports the product infrastructure and is not intended to be used directly from your code. Gets or sets a value that indicates whether all user-defined types are transferred from the source to the target database.

System_CAPS_pubpropertyCopyAllUsers

This API supports the product infrastructure and is not intended to be used directly from your code. Gets or sets a value that indicates whether all the SQL Server database users are copied from the source database to the target database.

System_CAPS_pubpropertyCopyAllViews

This API supports the product infrastructure and is not intended to be used directly from your code. Gets or sets a value that indicates whether all SQL Server views are transferred from the source to the target database.

System_CAPS_pubpropertyCopyAllXmlSchemaCollections

This API supports the product infrastructure and is not intended to be used directly from your code. Gets or sets a value that indicates whether all XML schema collections are transferred from the source to the target database.

System_CAPS_pubpropertyCopyData

This API supports the product infrastructure and is not intended to be used directly from your code. Gets or sets a value that indicates whether the data is transferred from the SQL Server source to the target database.

System_CAPS_pubpropertyCopyDatabaseRoles

This API supports the product infrastructure and is not intended to be used directly from your code. Gets or sets a value that indicates whether database roles are transferred from the source to the target database.

System_CAPS_pubpropertyCopyDatabaseUsers

This API supports the product infrastructure and is not intended to be used directly from your code. Gets or sets a value that indicates whether database users are transferred from the source to the target database.

System_CAPS_pubpropertyCopyForeignKeys

This API supports the product infrastructure and is not intended to be used directly from your code. Gets or sets a value that indicates whether foreign keys are transferred from the source to the target database.

System_CAPS_pubpropertyCopyFullTextIndexes

This API supports the product infrastructure and is not intended to be used directly from your code. Gets or sets a value that indicates whether full-text properties are transferred from the source to the target database.

System_CAPS_pubpropertyCopyIndexes

This API supports the product infrastructure and is not intended to be used directly from your code. Gets or sets a value that indicates whether indexes are transferred from the source to the target database.

System_CAPS_pubpropertyCopyObjectLevelPermissions

This API supports the product infrastructure and is not intended to be used directly from your code. Gets or sets a value that indicates whether securable objects are included in the transfer from the source to the target database.

System_CAPS_pubpropertyCopyPrimaryKeys

This API supports the product infrastructure and is not intended to be used directly from your code. Gets or sets a value that indicates whether primary keys are transferred from the source to the target database.

System_CAPS_pubpropertyCopySchema

This API supports the product infrastructure and is not intended to be used directly from your code. Gets or sets a value that indicates whether the schema is copied from the source database to the target database.

System_CAPS_pubpropertyCopySqlServerLogins

This API supports the product infrastructure and is not intended to be used directly from your code. Gets or sets a value that indicates whether SQL Server logins are included in the transfer from the source to the target database.

System_CAPS_pubpropertyCopyTriggers

This API supports the product infrastructure and is not intended to be used directly from your code. Gets or sets a value that indicates whether triggers are transferred from the source to the target database.

System_CAPS_pubpropertyDefaultsList

This API supports the product infrastructure and is not intended to be used directly from your code. Gets or sets the default objects to transfer.

System_CAPS_pubpropertyDestinationConnection

This API supports the product infrastructure and is not intended to be used directly from your code. Gets or sets the name of the destination connection.

System_CAPS_pubpropertyDestinationDatabase

This API supports the product infrastructure and is not intended to be used directly from your code. Gets or sets the name of the destination database.

System_CAPS_pubpropertyDestinationTranslateChar

This API supports the product infrastructure and is not intended to be used directly from your code. Gets or sets a value that indicates whether the character data is translated from the destination database.

System_CAPS_pubpropertyDropObjectsFirst

This API supports the product infrastructure and is not intended to be used directly from your code. Gets or sets a value that indicates whether objects at the destination are dropped before copying is started.

System_CAPS_pubpropertyExistingData

This API supports the product infrastructure and is not intended to be used directly from your code. Gets or sets a value from the ExistingData enumeration to determine whether data should be appended to existing data.

System_CAPS_pubpropertyGenerateScriptsInUnicode

This API supports the product infrastructure and is not intended to be used directly from your code. Gets or sets a value that indicates whether the script generated is in Unicode format.

System_CAPS_pubpropertyIncludeDependentObjects

This API supports the product infrastructure and is not intended to be used directly from your code. Gets or sets a value that indicates whether the dependent objects are included in the transfer.

System_CAPS_pubpropertyIncludeExtendedProperties

This API supports the product infrastructure and is not intended to be used directly from your code. Gets or sets a value that indicates whether extended properties are transferred from the source to the target database.

System_CAPS_pubpropertyLoginsList

This API supports the product infrastructure and is not intended to be used directly from your code. Gets or sets the list of logins to transfer.

System_CAPS_pubpropertyPartitionFunctionsList

This API supports the product infrastructure and is not intended to be used directly from your code. Gets or sets the list of partition functions to transfer.

System_CAPS_pubpropertyPartitionSchemesList

This API supports the product infrastructure and is not intended to be used directly from your code. Gets or sets the list of partition schemes to transfer.

System_CAPS_pubpropertyRulesList

This API supports the product infrastructure and is not intended to be used directly from your code. Gets or sets the list of rules to transfer.

System_CAPS_pubpropertySchemasList

This API supports the product infrastructure and is not intended to be used directly from your code. Gets or sets the list of schemas to transfer.

System_CAPS_pubpropertySourceConnection

This API supports the product infrastructure and is not intended to be used directly from your code. Gets or sets the name of the connection manager for the source database.

System_CAPS_pubpropertySourceDatabase

This API supports the product infrastructure and is not intended to be used directly from your code. Gets or sets the name of the database from which objects will be transferred.

System_CAPS_pubpropertySourceTranslateChar

This API supports the product infrastructure and is not intended to be used directly from your code. Gets or sets a value that indicates whether the character data is translated from the source database.

System_CAPS_pubpropertySqlAssembliesList

This API supports the product infrastructure and is not intended to be used directly from your code. Gets or sets the list of SQL Server assemblies to transfer.

System_CAPS_pubpropertyStoredProceduresList

This API supports the product infrastructure and is not intended to be used directly from your code. Gets or sets the list of stored procedures to transfer.

System_CAPS_pubpropertyTablesList

This API supports the product infrastructure and is not intended to be used directly from your code. Gets or sets the list of tables to transfer.

System_CAPS_pubpropertyUseCollation

This API supports the product infrastructure and is not intended to be used directly from your code. Gets or sets a value that indicates whether the transfer should use collations.

System_CAPS_pubpropertyUserDefinedAggregatesList

This API supports the product infrastructure and is not intended to be used directly from your code. Gets or sets a list of user-defined aggregates to transfer.

System_CAPS_pubpropertyUserDefinedDataTypesList

This API supports the product infrastructure and is not intended to be used directly from your code. Gets or sets the list of user-defined data types to transfer.

System_CAPS_pubpropertyUserDefinedFunctionsList

This API supports the product infrastructure and is not intended to be used directly from your code. Gets or sets a list of user-defined functions to transfer.

System_CAPS_pubpropertyUserDefinedTypesList

This API supports the product infrastructure and is not intended to be used directly from your code. Gets or sets a list of user-defined types to transfer.

System_CAPS_pubpropertyUsersList

This API supports the product infrastructure and is not intended to be used directly from your code. Gets or sets a list of users to transfer.

System_CAPS_pubpropertyViewsList

This API supports the product infrastructure and is not intended to be used directly from your code. Gets or sets a list of views to transfer.

System_CAPS_pubpropertyXmlSchemaCollectionsList

This API supports the product infrastructure and is not intended to be used directly from your code. Gets or sets a list of XML schema collections to transfer.

Return to top

Community Additions

Show:
© 2015 Microsoft