Share via

ITransferSqlServerObjectsTask Interface

  • Article

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)

Syntax

'Declaration
Public Interface ITransferSqlServerObjectsTask
'Usage
Dim instance As ITransferSqlServerObjectsTask

public interface ITransferSqlServerObjectsTask

public interface class ITransferSqlServerObjectsTask

type ITransferSqlServerObjectsTask =  interface end

public interface ITransferSqlServerObjectsTask

The ITransferSqlServerObjectsTask type exposes the following members.

Properties

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

Top

See Also

Reference

Microsoft.SqlServer.Dts.Tasks.TransferSqlServerObjectsTask Namespace