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