ITransferSqlServerObjectsTask Interface
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
Represents a Transfer SQL Server Objects task.
public interface class ITransferSqlServerObjectsTaskpublic interface ITransferSqlServerObjectsTasktype ITransferSqlServerObjectsTask = interfacePublic 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. |