TransferSqlServerObjectsTask Members

  • Article

Contains the methods and properties that allow you to copy various SQL Server objects from one server to another. This class cannot be inherited.

The following tables list the members exposed by the TransferSqlServerObjectsTask type.

Public Constructors

  Name Description
TransferSqlServerObjectsTask Initializes a new instance of the TransferSqlServerObjectsTask class.

Top

Public Properties

  Name Description
ms215221.pubproperty(en-US,SQL.90).gif CopyAllDefaults Gets or sets a Boolean indicating that the transfer includes the SQL Server defaults.
ms215221.pubproperty(en-US,SQL.90).gif CopyAllLogins Gets or sets a Boolean indicating whether all the SQL Server logins are copied from the source database to the target database in the transfer operation, or only the specified logins.
ms215221.pubproperty(en-US,SQL.90).gif CopyAllObjects Gets or sets a Boolean indicating whether all SQL Server database objects are transferred from the source to the target database, or only the specified objects. The following SQL Server database objects can be transferred: defaults, rules, stored procedures, tables, triggers, user-defined data types, and views.
ms215221.pubproperty(en-US,SQL.90).gif CopyAllPartitionFunctions Gets or sets a Boolean indicating whether all SQL Server partitions are transferred from the source to the target database, or only the specified partitions.
ms215221.pubproperty(en-US,SQL.90).gif CopyAllPartitionSchemes Gets or sets a Boolean indicating whether all SQL Server partition schemes are transferred from the source to the target database, or only the specified partition schemes.
ms215221.pubproperty(en-US,SQL.90).gif CopyAllRules Gets or sets a Boolean indicating whether all SQL Server rules are transferred from the source to the target database, or only the specified rules.
ms215221.pubproperty(en-US,SQL.90).gif CopyAllSchemas Gets or sets a Boolean indicating whether all SQL Server schemas are transferred from the source to the target database, or only the specified schemas.
ms215221.pubproperty(en-US,SQL.90).gif CopyAllSqlAssemblies Gets or sets a Boolean indicating whether all SQL Server assemblies are transferred from the source to the target database, or only the specified assemblies.
ms215221.pubproperty(en-US,SQL.90).gif CopyAllStoredProcedures Gets or sets a Boolean indicating whether all SQL Server stored procedures are transferred from the source to the target database, or only the specified stored procedures.
ms215221.pubproperty(en-US,SQL.90).gif CopyAllTables Gets or sets a Boolean indicating whether all SQL Server tables are transferred from the source to the target database, or only the specified tables.
ms215221.pubproperty(en-US,SQL.90).gif CopyAllUserDefinedAggregates Gets or sets a Boolean indicating whether all user-defined aggregates are transferred from the source to the target database, or only the specified user-defined aggregates.
ms215221.pubproperty(en-US,SQL.90).gif CopyAllUserDefinedDataTypes Gets or sets a Boolean indicating whether all user-defined data types are transferred from the source to the target database, or only the specified user-defined data types.
ms215221.pubproperty(en-US,SQL.90).gif CopyAllUserDefinedFunctions Gets or sets a Boolean indicating whether all user-defined functions are transferred from the source to the target database, or only the specified user-defined functions.
ms215221.pubproperty(en-US,SQL.90).gif CopyAllUserDefinedTypes Gets or sets a Boolean indicating whether all user-defined types are transferred from the source to the target database, or only the specified user-defined types.
ms215221.pubproperty(en-US,SQL.90).gif CopyAllUsers Gets or sets a Boolean indicating whether all the SQL Server database users are copied from the source database to the target database, or only the specified users.
ms215221.pubproperty(en-US,SQL.90).gif CopyAllViews Gets or sets a Boolean indicating whether all SQL Server views are transferred from the source to the target database, or only the specified views.
ms215221.pubproperty(en-US,SQL.90).gif CopyAllXmlSchemaCollections Gets or sets a Boolean indicating whether all XML schema collections are transferred from the source to the target database, or only the specified XML schema collections.
ms215221.pubproperty(en-US,SQL.90).gif CopyData Gets or sets a Boolean indicating whether data is included as part of the transfer of tables and views from the SQL Server source to the target database.
ms215221.pubproperty(en-US,SQL.90).gif CopyDatabaseRoles Gets or sets a Boolean indicating whether database roles are transferred from the source to the target database.
ms215221.pubproperty(en-US,SQL.90).gif CopyDatabaseUsers Gets or sets a Boolean indicating whether database users are transferred from the source to the target database.
ms215221.pubproperty(en-US,SQL.90).gif CopyForeignKeys Gets or sets a Boolean indicating whether foreign keys are transferred from the source to the target database.
ms215221.pubproperty(en-US,SQL.90).gif CopyFullTextIndexes Gets or sets a Boolean indicating whether full-text properties are transferred from the source to the target database.
ms215221.pubproperty(en-US,SQL.90).gif CopyIndexes Gets or sets a Boolean indicating whether indexes are transferred from the source to the target database.
ms215221.pubproperty(en-US,SQL.90).gif CopyObjectLevelPermissions Gets or sets a Boolean indicating whether securable objects are included in the transfer from the source to the target database.
ms215221.pubproperty(en-US,SQL.90).gif CopyPrimaryKeys Gets or sets a Boolean indicating whether primary keys are transferred from the source to the target database.
ms215221.pubproperty(en-US,SQL.90).gif CopySchema Gets or sets a Boolean that specifies whether the schema is copied in the transfer operation. This property is only available for SQL Server 2005.
ms215221.pubproperty(en-US,SQL.90).gif CopySqlServerLogins Gets or sets a Boolean indicating whether SQL Server logins are included in the transfer from the source to the target database.
ms215221.pubproperty(en-US,SQL.90).gif CopyTriggers Gets or sets a Boolean indicating whether triggers are included in the transfer from the source to the target database.
ms215221.pubproperty(en-US,SQL.90).gif DebugMode Gets or sets a Boolean that indicates whether a task should determine whether breakpoints are enabled.
ms215221.pubproperty(en-US,SQL.90).gif DefaultsList Gets or sets a StringCollection containing the default objects to transfer when the CopyAllDefaults is set to false.
ms215221.pubproperty(en-US,SQL.90).gif DestinationConnection Gets or sets a String containing the name of the SMO connection manager for the destination database.
ms215221.pubproperty(en-US,SQL.90).gif DestinationDatabase Gets or sets a String containing the name of the destination database.
ms215221.pubproperty(en-US,SQL.90).gif DestinationTranslateChar Gets or sets a Boolean indicating the value of AutoTranslate in the OLE DB destination connection string.
ms215221.pubproperty(en-US,SQL.90).gif DropObjectsFirst Gets or sets a Boolean that indicates whether the objects that have been selected for transfer from the source are dropped first on the destination server before the transfer begins.
ms215221.pubproperty(en-US,SQL.90).gif ExecutionValue Overridden. Returns an object containing the count of the number of objects transferred.
ms215221.pubproperty(en-US,SQL.90).gif ExistingData Gets or sets a value from the ExistingData enumeration to determine whether data should be appended to existing data, or have the existing data replaced by being overwritten.
ms215221.pubproperty(en-US,SQL.90).gif GenerateScriptsInUnicode Gets or sets a Boolean that indicates whether the script generated is in Unicode format.
ms215221.pubproperty(en-US,SQL.90).gif IncludeDependentObjects Gets or sets a Boolean that indicates whether the dependent objects are included in the transfer.
ms215221.pubproperty(en-US,SQL.90).gif IncludeExtendedProperties Gets or sets a Boolean indicating whether extended properties are transferred from the source to the target database.
ms215221.pubproperty(en-US,SQL.90).gif LoginsList Gets or sets a StringCollection containing the SQL Server logins to transfer from the source database to the destination database when CopyAllLogins is false.
ms215221.pubproperty(en-US,SQL.90).gif PartitionFunctionsList Gets or sets a StringCollection containing the partition functions to transfer from the source database to the destination database when the CopyAllPartitionFunctions is false.
ms215221.pubproperty(en-US,SQL.90).gif PartitionSchemesList Gets or sets a StringCollection containing the partition schemes to transfer from the source database to the destination database when CopyAllPartitionSchemes is false.
ms215221.pubproperty(en-US,SQL.90).gif RulesList Gets or sets a StringCollection containing the rules to transfer from the source database to the destination database when CopyAllRules is false.
ms215221.pubproperty(en-US,SQL.90).gif SchemasList Gets or sets a StringCollection containing the list of schemas to transfer from the source database to the destination database when CopyAllSchemas is false.
ms215221.pubproperty(en-US,SQL.90).gif SourceConnection Gets or sets a String containing the name of the SMO connection manager for the source database.
ms215221.pubproperty(en-US,SQL.90).gif SourceDatabase Gets or sets a String containing the name of the database from which objects will be transferred.
ms215221.pubproperty(en-US,SQL.90).gif SourceTranslateChar Gets or sets a Boolean indicating the value of AutoTranslate in the OLE DB source connection string.
ms215221.pubproperty(en-US,SQL.90).gif SqlAssembliesList Gets or sets a StringCollection listing the SQL Server assemblies to transfer when CopyAllSqlAssemblies is false.
ms215221.pubproperty(en-US,SQL.90).gif StoredProceduresList Gets or sets a StringCollection listing the stored procedures to transfer when CopyAllStoredProcedures is false.
ms215221.pubproperty(en-US,SQL.90).gif SuspendRequired Gets or sets a Boolean that indicates whether tasks should suspend when they encounter a breakpoint. This value is set by the run-time engine for tasks and containers when a breakpoint is encountered.
ms215221.pubproperty(en-US,SQL.90).gif TablesList Gets or sets a StringCollection listing the tables to transfer when CopyAllTables is false.
ms215221.pubproperty(en-US,SQL.90).gif UseCollation Gets or sets a Boolean indicating whether the transfer should use collations.
ms215221.pubproperty(en-US,SQL.90).gif UserDefinedAggregatesList Gets or sets a StringCollection listing the user-defined aggregates to transfer when CopyAllUserDefinedAggregates is false.
ms215221.pubproperty(en-US,SQL.90).gif UserDefinedDataTypesList Gets or sets a StringCollection listing the user-defined data types to transfer when CopyAllUserDefinedDataTypes is false.
ms215221.pubproperty(en-US,SQL.90).gif UserDefinedFunctionsList Gets or sets a StringCollection listing the user-defined functions to transfer when CopyAllUserDefinedFunctions is false.
ms215221.pubproperty(en-US,SQL.90).gif UserDefinedTypesList Gets or sets a StringCollection listing the user-defined types to transfer when CopyAllUserDefinedTypes is false.
ms215221.pubproperty(en-US,SQL.90).gif UsersList Gets or sets a StringCollection containing the SQL Server database users to transfer from the source database to the destination database when CopyAllUsers is false.
ms215221.pubproperty(en-US,SQL.90).gif Version  Returns the version of the task. This property is read-only. (inherited from Task)
ms215221.pubproperty(en-US,SQL.90).gif ViewsList Gets or sets a StringCollection listing the views to transfer when CopyAllViews is false.
ms215221.pubproperty(en-US,SQL.90).gif WaitForMe  Returns a Boolean that indicates whether the parent container should wait for completion of this task. This property is read-only. (inherited from Task)
ms215221.pubproperty(en-US,SQL.90).gif XmlSchemaCollectionsList Gets or sets a StringCollection listing the XML schema collections to transfer when CopyAllXmlSchemaCollections is false.

Top

Public Methods

(see also Protected Methods )

  Name Description
ms215221.pubmethod(en-US,SQL.90).gif AcceptBreakpointManager Passes a BreakpointManager to a task. This method is called by the runtime and is not used in code.
ms215221.pubmethod(en-US,SQL.90).gif CanUpdate  (inherited from Task )
ms215221.pubmethod(en-US,SQL.90).gif Equals  Overloaded. (inherited from DtsObject )
ms215221.pubmethod(en-US,SQL.90).gif Execute Overridden. Runs the task.
ms215221.pubmethod(en-US,SQL.90).gif GetConnectionID  (inherited from Task )
ms215221.pubmethod(en-US,SQL.90).gif GetConnectionName  (inherited from Task )
ms215221.pubmethod(en-US,SQL.90).gif GetHashCode  Returns the hash code for this instance. (inherited from DtsObject)
ms215221.pubmethod(en-US,SQL.90).gif GetType  (inherited from Object )
ms215221.pubmethod(en-US,SQL.90).gif InitializeTask Overridden. Initializes the properties associated with the task. This method is called by the runtime and is not used in code.
ms215221.pubmethod(en-US,SQL.90).gif LoadFromXML This method is not callable by your application code. To load a package saved as .xml, use the Application.LoadPackage method.
ms215221.pubmethod(en-US,SQL.90).gifms215221.static(en-US,SQL.90).gif op_Equality  (inherited from DtsObject )
ms215221.pubmethod(en-US,SQL.90).gifms215221.static(en-US,SQL.90).gif op_Inequality  (inherited from DtsObject )
ms215221.pubmethod(en-US,SQL.90).gifms215221.static(en-US,SQL.90).gif ReferenceEquals  (inherited from Object )
ms215221.pubmethod(en-US,SQL.90).gif ResumeExecution Resumes execution of the task after pausing. The task or container is resumed by the run-time engine.
ms215221.pubmethod(en-US,SQL.90).gif SaveToXML This method is not callable by your application code. To save a package as .xml, use the Application.SaveToXml method.
ms215221.pubmethod(en-US,SQL.90).gif SuspendExecution Indicates that the executable needs to suspend. This method is called by the run-time engine.
ms215221.pubmethod(en-US,SQL.90).gif ToString  (inherited from Object )
ms215221.pubmethod(en-US,SQL.90).gif Update  (inherited from Task )
ms215221.pubmethod(en-US,SQL.90).gif Validate Overridden. Verifies that the task is properly configured.

Top

Protected Methods

  Name Description
ms215221.protmethod(en-US,SQL.90).gif Finalize  (inherited from Object )
ms215221.protmethod(en-US,SQL.90).gif MemberwiseClone  (inherited from Object )

Top

See Also

Reference

TransferSqlServerObjectsTask Class
Microsoft.SqlServer.Dts.Tasks.TransferSqlServerObjectsTask Namespace