Share via


ITransferSqlServerObjectsTask Interface

Definition

Represents a Transfer SQL Server Objects task.

public interface class ITransferSqlServerObjectsTask
public interface ITransferSqlServerObjectsTask
type ITransferSqlServerObjectsTask = interface
Public Interface ITransferSqlServerObjectsTask
Derived

Properties

CopyAllDefaults

Gets or sets a value that indicates whether the transfer includes the SQL Server defaults.

CopyAllLogins

Gets or sets a value that indicates whether all the SQL Server logins are copied from the source database to the target database.

CopyAllObjects

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

Gets or sets a value that indicates whether all SQL Server partitions are transferred from the source to the target database.

CopyAllPartitionSchemes

Gets or sets a value that indicates whether all SQL Server partition schemes are transferred from the source to the target database.

CopyAllRules

Gets or sets a value that indicates whether all SQL Server rules are transferred from the source to the target database.

CopyAllSchemas

Gets or sets a value that indicates whether all SQL Server schemas are transferred from the source to the target database.

CopyAllSqlAssemblies

Gets or sets a value that indicates whether all SQL Server assemblies are transferred from the source to the target database.

CopyAllStoredProcedures

Gets or sets a value that indicates whether all SQL Server stored procedures are transferred from the source to the target database.

CopyAllTables

Gets or sets a value that indicates whether all SQL Server tables are transferred from the source to the target database.

CopyAllUserDefinedAggregates

Gets or sets a value that indicates whether all user-defined aggregates are transferred from the source to the target database.

CopyAllUserDefinedDataTypes

Gets or sets a value that indicates whether all user-defined data types are transferred from the source to the target database.

CopyAllUserDefinedFunctions

Gets or sets a value that indicates whether all user-defined functions are transferred from the source to the target database.

CopyAllUserDefinedTypes

Gets or sets a value that indicates whether all user-defined types are transferred from the source to the target database.

CopyAllUsers

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

Gets or sets a value that indicates whether all SQL Server views are transferred from the source to the target database.

CopyAllXmlSchemaCollections

Gets or sets a value that indicates whether all XML schema collections are transferred from the source to the target database.

CopyData

Gets or sets a value that indicates whether the data is transferred from the SQL Server source to the target database.

CopyDatabaseRoles

Gets or sets a value that indicates whether database roles are transferred from the source to the target database.

CopyDatabaseUsers

Gets or sets a value that indicates whether database users are transferred from the source to the target database.

CopyForeignKeys

Gets or sets a value that indicates whether foreign keys are transferred from the source to the target database.

CopyFullTextIndexes

Gets or sets a value that indicates whether full-text properties are transferred from the source to the target database.

CopyIndexes

Gets or sets a value that indicates whether indexes are transferred from the source to the target database.

CopyObjectLevelPermissions

Gets or sets a value that indicates whether securable objects are included in the transfer from the source to the target database.

CopyPrimaryKeys

Gets or sets a value that indicates whether primary keys are transferred from the source to the target database.

CopySchema

Gets or sets a value that indicates whether the schema is copied from the source database to the target database.

CopySqlServerLogins

Gets or sets a value that indicates whether SQL Server logins are included in the transfer from the source to the target database.

CopyTriggers

Gets or sets a value that indicates whether triggers are transferred from the source to the target database.

DefaultsList

Gets or sets the default objects to transfer.

DestinationConnection

Gets or sets the name of the destination connection.

DestinationDatabase

Gets or sets the name of the destination database.

DestinationTranslateChar

Gets or sets a value that indicates whether the character data is translated from the destination database.

DropObjectsFirst

Gets or sets a value that indicates whether objects at the destination are dropped before copying is started.

ExistingData

Gets or sets a value from the ExistingData enumeration to determine whether data should be appended to existing data.

GenerateScriptsInUnicode

Gets or sets a value that indicates whether the script generated is in Unicode format.

IncludeDependentObjects

Gets or sets a value that indicates whether the dependent objects are included in the transfer.

IncludeExtendedProperties

Gets or sets a value that indicates whether extended properties are transferred from the source to the target database.

LoginsList

Gets or sets the list of logins to transfer.

PartitionFunctionsList

Gets or sets the list of partition functions to transfer.

PartitionSchemesList

Gets or sets the list of partition schemes to transfer.

RulesList

Gets or sets the list of rules to transfer.

SchemasList

Gets or sets the list of schemas to transfer.

SourceConnection

Gets or sets the name of the connection manager for the source database.

SourceDatabase

Gets or sets the name of the database from which objects will be transferred.

SourceTranslateChar

Gets or sets a value that indicates whether the character data is translated from the source database.

SqlAssembliesList

Gets or sets the list of SQL Server assemblies to transfer.

StoredProceduresList

Gets or sets the list of stored procedures to transfer.

TablesList

Gets or sets the list of tables to transfer.

UseCollation

Gets or sets a value that indicates whether the transfer should use collations.

UserDefinedAggregatesList

Gets or sets a list of user-defined aggregates to transfer.

UserDefinedDataTypesList

Gets or sets the list of user-defined data types to transfer.

UserDefinedFunctionsList

Gets or sets a list of user-defined functions to transfer.

UserDefinedTypesList

Gets or sets a list of user-defined types to transfer.

UsersList

Gets or sets a list of users to transfer.

ViewsList

Gets or sets a list of views to transfer.

XmlSchemaCollectionsList

Gets or sets a list of XML schema collections to transfer.

Applies to