Transfer Members

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

	名稱	Description
	Transfer	Overloaded. Initializes a new instance of the Transfer class.

頂端

Public Properties

	名稱	Description
	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.
	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.
	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.
	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.
	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.
	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.
	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.
	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.
	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.
	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.
	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.
	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.
	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.
	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.
	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.
	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.
	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.
	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.
	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.
	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.
	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.
	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.
	CreateTargetDatabase	Gets or sets the Boolean property value that specifies whether the target database is created in the transfer operation.
	Database	Gets or sets the database from which schema or data is to be transferred to the target location.
	DestinationDatabase	Gets or sets the database that is the destination of the transfer operation.
	DestinationLogin	Gets or sets the logon for the instance of Microsoft SQL Server to which the destination database belongs.
	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.
	DestinationPassword	Gets or sets the logon password for the instance of Microsoft SQL Server to which the destination database belongs.
	DestinationServer	Gets or sets the instance of Microsoft SQL Server that owns the database that is the destination of the transfer operation.
	DestinationTranslateChar	Gets or sets the Boolean property value that specifies whether the transfer operation translates the code page for characters on the destination database.
	DropDestinationObjectsFirst	Gets or sets the Boolean property value that specifies whether to drop the objects in the destination database before the transfer operation.
	ObjectList	Gets or sets the objects copied from the source to destination in the transfer operation.
	Options	Gets or sets the options for the transfer operation.
	PrefetchObjects	Gets or sets the Boolean property that specifies whether to prefetch the objects before the transfer operation.
	SourceTranslateChar	Gets or sets the Boolean property value that specifies whether the transfer operation translates the code page for characters on the source database.
	TargetDatabaseFilePath
	TargetLogFilePath
	TemporaryPackageDirectory	Gets or sets the file location for storage of temporary packages created during the transfer operation.
	UseDestinationTransaction	Gets or sets the Boolean property value that specifies whether to use the destination transaction.

頂端

Public Methods

(see also Protected Methods )

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

頂端

Protected Methods

	名稱	Description
	Finalize	(inherited from Object )
	MemberwiseClone	(inherited from Object )

頂端

Public Events

	名稱	Description
	DataTransferEvent	Reports that data has been transferred.
	DiscoveryProgress	Marks the progress of the discovery process.
	ScriptingError	Reports that an error occurred during the scripting process.
	ScriptingProgress	Marks the progress of the scripting process.

頂端

Explicit Interface Implementations

	名稱	Description
	Microsoft.SqlServer.Management.Common.ITransferMetadataProvider.GetOptions
	Microsoft.SqlServer.Management.Common.ITransferMetadataProvider.SaveMetadata

頂端

請參閱

參考

Transfer Class
Microsoft.SqlServer.Management.Smo Namespace

其他資源

Transferring Data