Transfer Members

  • Article

The Transfer object is a tool object that provides programmatic control over copying of schemas and data to other instances of Microsoft SQL Server.

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

Public Constructors

  Name Description
Transfer Overloaded. Initializes a new instance of the Transfer class.

Top

Public Properties

  Name Description
ms220543.pubproperty(en-US,SQL.90).gif CopyAllDatabaseTriggers Gets or sets the Boolean property value that specifies whether all the Microsoft SQL Server database triggers are copied from the source database to the target database in the transfer operation.
ms220543.pubproperty(en-US,SQL.90).gif CopyAllDefaults Gets or sets the Boolean property value that specifies whether all the Microsoft SQL Server defaults are copied from the source database to the target database in the transfer operation.
ms220543.pubproperty(en-US,SQL.90).gif CopyAllLogins Gets or sets the Boolean property value that specifies whether all the Microsoft SQL Server logins are copied from the source database to the target database in the transfer operation.
ms220543.pubproperty(en-US,SQL.90).gif CopyAllObjects Gets or sets the Boolean property value that specifies whether all the Microsoft SQL Server objects are copied from the source database to the target database in the transfer operation.
ms220543.pubproperty(en-US,SQL.90).gif CopyAllPartitionFunctions Gets or sets the Boolean property value that specifies whether all the Microsoft SQL Server partition functions are copied from the source database to the target database in the transfer operation.
ms220543.pubproperty(en-US,SQL.90).gif CopyAllPartitionSchemes Gets or sets the Boolean property value that specifies whether all the Microsoft SQL Server partition schemes are copied from the source database to the target database in the transfer operation.
ms220543.pubproperty(en-US,SQL.90).gif CopyAllRoles Gets or sets the Boolean property value that specifies whether all the Microsoft SQL Server roles are copied from the source database to the target database in the transfer operation.
ms220543.pubproperty(en-US,SQL.90).gif CopyAllRules Gets or sets the Boolean property value that specifies whether all the Microsoft SQL Server rules are copied from the source database to the target database in the transfer operation.
ms220543.pubproperty(en-US,SQL.90).gif CopyAllSchemas Gets or sets the Boolean property value that specifies whether all the Microsoft SQL Server schemas are copied from the source database to the target database in the transfer operation.
ms220543.pubproperty(en-US,SQL.90).gif CopyAllSqlAssemblies Gets or sets the Boolean property value that specifies whether all the Microsoft SQL Server assemblies are copied from the source database to the target database in the transfer operation.
ms220543.pubproperty(en-US,SQL.90).gif CopyAllStoredProcedures Gets or sets the Boolean property value that specifies whether all the Microsoft SQL Server stored procedures are copied from the source database to the target database in the transfer operation.
ms220543.pubproperty(en-US,SQL.90).gif CopyAllSynonyms Gets or sets the Boolean property value that specifies whether all the Microsoft SQL Server synonyms are copied from the source database to the target database in the transfer operation.
ms220543.pubproperty(en-US,SQL.90).gif CopyAllTables Gets or sets the Boolean property value that specifies whether all the Microsoft SQL Server tables are copied from the source database to the target database in the transfer operation.
ms220543.pubproperty(en-US,SQL.90).gif CopyAllUserDefinedAggregates Gets or sets the Boolean property value that specifies whether all the Microsoft SQL Server user-defined aggregates are copied from the source database to the target database in the transfer operation.
ms220543.pubproperty(en-US,SQL.90).gif CopyAllUserDefinedDataTypes Gets or sets the Boolean property value that specifies whether all the Microsoft SQL Server user-defined data types are copied from the source database to the target database in the transfer operation.
ms220543.pubproperty(en-US,SQL.90).gif CopyAllUserDefinedFunctions Gets or sets the Boolean property value that specifies whether all the Microsoft SQL Server user-defined functions are copied from the source database to the target database in the transfer operation.
ms220543.pubproperty(en-US,SQL.90).gif CopyAllUserDefinedTypes Gets or sets the Boolean property value that specifies whether all the Microsoft SQL Server user-defined types are copied from the source database to the target database in the transfer operation.
ms220543.pubproperty(en-US,SQL.90).gif CopyAllUsers Gets or sets the Boolean property value that specifies whether all the Microsoft SQL Server database users are copied from the source database to the target database in the transfer operation.
ms220543.pubproperty(en-US,SQL.90).gif CopyAllViews Gets or sets the Boolean property value that specifies whether all the Microsoft SQL Server views are copied from the source database to the target database in the transfer operation.
ms220543.pubproperty(en-US,SQL.90).gif CopyAllXmlSchemaCollections Gets or sets the Boolean property value that specifies whether all the Microsoft SQL Server XML schema collections are copied from the source database to the target database in the transfer operation.
ms220543.pubproperty(en-US,SQL.90).gif CopyData Gets or sets the Boolean property value that specifies whether all the data is copied from the source database to the target database in the transfer operation.
ms220543.pubproperty(en-US,SQL.90).gif CopySchema Gets or sets the Boolean property value that specifies whether the schema is copied from the source database to the target database in the transfer operation.
ms220543.pubproperty(en-US,SQL.90).gif CreateTargetDatabase Gets or sets the Boolean property value that specifies whether the target database is created in the transfer operation.
ms220543.pubproperty(en-US,SQL.90).gif Database Gets or sets the database from which schema or data is to be transferred to the target location.
ms220543.pubproperty(en-US,SQL.90).gif DestinationDatabase Gets or sets the database that is the destination of the transfer operation.
ms220543.pubproperty(en-US,SQL.90).gif DestinationLogin Gets or sets the logon for the instance of Microsoft SQL Server to which the destination database belongs.
ms220543.pubproperty(en-US,SQL.90).gif DestinationLoginSecure Gets or sets the Boolean property that specifies whether the instance of Microsoft SQL Server that contains the destination database is enabled for Microsoft Windows Authentication or not.
ms220543.pubproperty(en-US,SQL.90).gif DestinationPassword Gets or sets the logon password for the instance of Microsoft SQL Server to which the destination database belongs.
ms220543.pubproperty(en-US,SQL.90).gif DestinationServer Gets or sets the instance of Microsoft SQL Server that owns the database that is the destination of the transfer operation.
ms220543.pubproperty(en-US,SQL.90).gif DestinationTranslateChar Gets or sets the Boolean property value that specifies whether the transfer operation translates the code page for characters on the destination database.
ms220543.pubproperty(en-US,SQL.90).gif DropDestinationObjectsFirst Gets or sets the Boolean property value that specifies whether to drop the objects in the destination database before the transfer operation.
ms220543.pubproperty(en-US,SQL.90).gif ObjectList Gets or sets the objects copied from the source to destination in the transfer operation.
ms220543.pubproperty(en-US,SQL.90).gif Options Gets or sets the options for the transfer operation.
ms220543.pubproperty(en-US,SQL.90).gif PrefetchObjects Gets or sets the Boolean property that specifies whether to prefetch the objects before the transfer operation.
ms220543.pubproperty(en-US,SQL.90).gif SourceTranslateChar Gets or sets the Boolean property value that specifies whether the transfer operation translates the code page for characters on the source database.
ms220543.pubproperty(en-US,SQL.90).gif TargetDatabaseFilePath  
ms220543.pubproperty(en-US,SQL.90).gif TargetLogFilePath  
ms220543.pubproperty(en-US,SQL.90).gif TemporaryPackageDirectory Gets or sets the file location for storage of temporary packages created during the transfer operation.
ms220543.pubproperty(en-US,SQL.90).gif UseDestinationTransaction Gets or sets the Boolean property value that specifies whether to use the destination transaction.

Top

Public Methods

(see also Protected Methods )

  Name Description
ms220543.pubmethod(en-US,SQL.90).gif EnumObjects Returns an enumerated list of Uniform Resource Name (URN) values that represent the objects included in the transfer operation.
ms220543.pubmethod(en-US,SQL.90).gif Equals  Overloaded. (inherited from Object )
ms220543.pubmethod(en-US,SQL.90).gif GetHashCode  (inherited from Object )
ms220543.pubmethod(en-US,SQL.90).gif GetTransferProvider Returns the data transfer provider interface.
ms220543.pubmethod(en-US,SQL.90).gif GetType  (inherited from Object )
ms220543.pubmethod(en-US,SQL.90).gifms220543.static(en-US,SQL.90).gif ReferenceEquals  (inherited from Object )
ms220543.pubmethod(en-US,SQL.90).gif ScriptTransfer Creates a Transact-SQL command batch script that creates database objects that are transferred by the transfer operation.
ms220543.pubmethod(en-US,SQL.90).gif ToString  (inherited from Object )
ms220543.pubmethod(en-US,SQL.90).gif TransferData Transfers data as specified by the Transfer object.

Top

Protected Methods

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

Top

Public Events

  Name Description
ms220543.pubevent(en-US,SQL.90).gif DataTransferEvent Reports that data has been transferred.
ms220543.pubevent(en-US,SQL.90).gif DiscoveryProgress Marks the progress of the discovery process.
ms220543.pubevent(en-US,SQL.90).gif ScriptingError Reports that an error occurred during the scripting process.
ms220543.pubevent(en-US,SQL.90).gif ScriptingProgress Marks the progress of the scripting process.

Top

Explicit Interface Implementations

  Name Description
Microsoft.SqlServer.Management.Common.ITransferMetadataProvider.GetOptions  
Microsoft.SqlServer.Management.Common.ITransferMetadataProvider.SaveMetadata  

Top

See Also

Reference

Transfer Class
Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Transferring Data