Transfer 類別
The Transfer object is a tool object that provides programmatic control over copying of schemas and data to other instances of SQL Server.
繼承階層
System.Object
Microsoft.SqlServer.Management.Smo.TransferBase
Microsoft.SqlServer.Management.Smo.DataTransferBase
Microsoft.SqlServer.Management.Smo.Transfer
命名空間： Microsoft.SqlServer.Management.Smo
組件： Microsoft.SqlServer.SmoExtended (在 Microsoft.SqlServer.SmoExtended.dll 中)
語法
'宣告
Public Class Transfer _
Inherits DataTransferBase _
Implements ITransferMetadataProvider
'用途
Dim instance As Transfer
public class Transfer : DataTransferBase, ITransferMetadataProvider
public ref class Transfer : public DataTransferBase,
ITransferMetadataProvider
type Transfer =
class
inherit DataTransferBase
interface ITransferMetadataProvider
end
public class Transfer extends DataTransferBase implements ITransferMetadataProvider
Transfer 型別公開下列成員。
建構函式
| 名稱 | 說明 | |
|---|---|---|
.gif "公用方法") |
Transfer() | Initializes a new instance of the Transfer class. |
|
Transfer(Database) | Initializes a new instance of the Transfer class that uses the specified database as the source of the transfer operation. |
上層
屬性
| 名稱 | 說明 | |
|---|---|---|
.gif "公用屬性") |
BatchSize | Gets or sets the batch size property. |
|
BulkCopyTimeout | Gets or sets the operation to complete before it times out. |
|
CopyAllDatabaseTriggers | Gets or sets a value that indicates whether all the SQL Server database triggers are copied from the source database to the target database in the transfer operation. (繼承自 TransferBase。) |
|
CopyAllDefaults | Gets or sets a value that indicates whether all the SQL Server defaults are copied from the source database to the target database in the transfer operation. (繼承自 TransferBase。) |
|
CopyAllFullTextCatalogs | Gets or sets a value that indicates whether all the SQL Server full-text catalogs are copied from the source database to the target database in the transfer operation. (繼承自 TransferBase。) |
|
CopyAllFullTextStopLists | Gets or sets a value that indicates whether all the SQL Server full-text stop lists are copied from the source database to the target database in the transfer operation. (繼承自 TransferBase。) |
|
CopyAllLogins | Gets or sets a value that indicates whether all the SQL Server logins are copied from the source database to the target database in the transfer operation. (繼承自 TransferBase。) |
|
CopyAllObjects | Gets or sets a value that indicates whether all the SQL Server objects are copied from the source database to the target database in the transfer operation. (繼承自 TransferBase。) |
|
CopyAllPartitionFunctions | Gets or sets a value that indicates whether all the SQL Server partition functions are copied from the source database to the target database in the transfer operation. (繼承自 TransferBase。) |
|
CopyAllPartitionSchemes | Gets or sets a value that indicates whether all the SQL Server partition schemes are copied from the source database to the target database in the transfer operation. (繼承自 TransferBase。) |
|
CopyAllPlanGuides | Gets or sets a value that indicates whether all the SQL Server plan guides are copied from the source database to the target database in the transfer operation. (繼承自 TransferBase。) |
|
CopyAllRoles | Gets or sets a value that indicates whether all the SQL Server roles are copied from the source database to the target database in the transfer operation. (繼承自 TransferBase。) |
|
CopyAllRules | Gets or sets a value that indicates whether all the SQL Server rules are copied from the source database to the target database in the transfer operation. (繼承自 TransferBase。) |
|
CopyAllSchemas | Gets or sets a value that indicates whether all the SQL Server schemas are copied from the source database to the target database in the transfer operation. (繼承自 TransferBase。) |
|
CopyAllSearchPropertyLists | Gets or sets a value that indicates whether all the SQL Server search property lists are copied from the source database to the target database in the transfer operation. (繼承自 TransferBase。) |
|
CopyAllSequences | Gets or sets a value that indicates whether all the SQL Server sequences are copied from the source database to the target database in the transfer operation. (繼承自 TransferBase。) |
|
CopyAllSqlAssemblies | Gets or sets a value that indicates whether all the SQL Server assemblies are copied from the source database to the target database in the transfer operation. (繼承自 TransferBase。) |
|
CopyAllStoredProcedures | Gets or sets a value that indicates whether all the SQL Server stored procedures are copied from the source database to the target database in the transfer operation. (繼承自 TransferBase。) |
|
CopyAllSynonyms | Gets or sets a value that indicates whether all the SQL Server synonyms are copied from the source database to the target database in the transfer operation. (繼承自 TransferBase。) |
|
CopyAllTables | Gets or sets a value that indicates whether all the SQL Server tables are copied from the source database to the target database in the transfer operation. (繼承自 TransferBase。) |
|
CopyAllUserDefinedAggregates | Gets or sets a value that indicates whether all the SQL Server user-defined aggregates are copied from the source database to the target database in the transfer operation. (繼承自 TransferBase。) |
|
CopyAllUserDefinedDataTypes | Gets or sets a value that indicates whether all the SQL Server user-defined data types are copied from the source database to the target database in the transfer operation. (繼承自 TransferBase。) |
|
CopyAllUserDefinedFunctions | Gets or sets a value that indicates whether all the SQL Server user-defined functions are copied from the source database to the target database in the transfer operation. (繼承自 TransferBase。) |
|
CopyAllUserDefinedTableTypes | Gets or sets a value that indicates whether all the SQL Server user-defined table types are copied from the source database to the target database in the transfer operation. (繼承自 TransferBase。) |
|
CopyAllUserDefinedTypes | Gets or sets a value that indicates whether all the SQL Server user-defined types are copied from the source database to the target database in the transfer operation. (繼承自 TransferBase。) |
|
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 in the transfer operation. (繼承自 TransferBase。) |
|
CopyAllViews | Gets or sets a value that indicates whether all the SQL Server views are copied from the source database to the target database in the transfer operation. (繼承自 TransferBase。) |
|
CopyAllXmlSchemaCollections | Gets or sets a value that indicates whether all the SQL Server XML schema collections are copied from the source database to the target database in the transfer operation. (繼承自 TransferBase。) |
|
CopyData | Gets or sets a value that indicates whether all the data is copied from the source database to the target database in the transfer operation. (繼承自 TransferBase。) |
|
CopySchema | Gets or sets a value that indicates whether the schema is copied from the source database to the target database in the transfer operation. (繼承自 TransferBase。) |
|
CreateTargetDatabase | Gets or sets a value that indicates whether the target database is created in the transfer operation. (繼承自 TransferBase。) |
|
Database | Gets or sets the database from which schema or data is to be transferred to the target location. (繼承自 TransferBase。) |
|
DatabaseFileMappings | Gets or sets the properties that are associated with flat file destination based on a dictionary. (繼承自 TransferBase。) |
|
DestinationDatabase | Gets or sets the database that is the destination of the transfer operation. (繼承自 TransferBase。) |
|
DestinationLogin | Gets or sets the logon for the instance of SQL Server to which the destination database belongs. (繼承自 TransferBase。) |
|
DestinationLoginSecure | Gets or sets a value that indicates whether the instance of SQL Server that contains the destination database is enabled for Windows Authentication or not. (繼承自 TransferBase。) |
|
DestinationPassword | Gets or sets the logon password for the instance of SQL Server to which the destination database belongs. (繼承自 TransferBase。) |
|
DestinationServer | Gets or sets the instance of SQL Server that owns the database that is the destination of the transfer operation. (繼承自 TransferBase。) |
|
DestinationTranslateChar | Gets or sets a value that indicates whether the transfer operation translates the code page for characters on the destination database. (繼承自 TransferBase。) |
|
DropDestinationObjectsFirst | Gets or sets a value that indicates whether to drop the objects in the destination database before the transfer operation. (繼承自 TransferBase。) |
|
ObjectList | Gets or sets the objects copied from the source to destination in the transfer operation. (繼承自 TransferBase。) |
|
Options | Gets or sets the options for the transfer operation. (繼承自 TransferBase。) |
|
PrefetchObjects | Gets or sets a value that indicates whether to prefetch the objects before the transfer operation. (繼承自 TransferBase。) |
|
PreserveDbo | Gets or sets a value that indicates whether DBO ownerships are retained through the transfer process. (繼承自 TransferBase。) |
|
PreserveLogins | Gets or sets a value that indicates whether to preserve logins in the transfer operation. (繼承自 TransferBase。) |
.gif "受保護的屬性") |
Scripter | Gets the scripter for the transfer operation. (繼承自 TransferBase。) |
|
SourceTranslateChar | Gets or sets a value that indicates whether the transfer operation translates the code page for characters on the source database. (繼承自 TransferBase。) |
|
TargetDatabaseFilePath | Gets or sets the path to where the database files will be copied. (繼承自 TransferBase。) |
|
TargetLogFilePath | Gets or sets the path to where the log files will be copied. (繼承自 TransferBase。) |
|
TemporaryPackageDirectory | For internal use only. The value of this property is ignored if set by a caller. |
|
UseDestinationTransaction | Gets or sets a value that indicates whether to use the destination transaction. (繼承自 TransferBase。) |
上層
方法
| 名稱 | 說明 | |
|---|---|---|
|
EnumObjects | Returns an enumerated list of Uniform Resource Name (URN) values that represent the objects included in the transfer operation. (繼承自 TransferBase。) |
|
EnumScriptTransfer | Creates a Transact-SQL command batch script used to transfer database objects or database objects and data to another database instance. (繼承自 TransferBase。) |
|
Equals | (繼承自 Object。) |
.gif "受保護的方法") |
Finalize | (繼承自 Object。) |
|
GetHashCode | (繼承自 Object。) |
|
GetTransferProvider | For internal use only. Throws a System.NotSupportedException if invoked by a caller. |
|
GetType | (繼承自 Object。) |
|
MemberwiseClone | (繼承自 Object。) |
.gif "靜態成員") |
ProcessDependencyChain | Returns a URN array with options. |
|
ScriptTransfer | Creates a Transact-SQL command batch script that creates database objects that are transferred by the transfer operation. (繼承自 TransferBase。) |
|
SetTargetServerInfo | Sets the target server version based on the SQL Server version. (繼承自 TransferBase。) |
|
ToString | (繼承自 Object。) |
|
TransferData | Transfers data as specified by the Transfer object. |
上層
事件
| 名稱 | 說明 | |
|---|---|---|
.gif "公用事件") |
DataTransferEvent | Reports that data has been transferred. |
|
DiscoveryProgress | Marks the progress of the discovery process. (繼承自 TransferBase。) |
|
ScriptingError | Reports that an error occurred during the scripting process. (繼承自 TransferBase。) |
|
ScriptingProgress | Marks the progress of the scripting process. (繼承自 TransferBase。) |
上層
明確 繼承 實作
| 名稱 | 說明 | |
|---|---|---|
.gif "明確介面實作") .gif "私用方法") |
ITransferMetadataProvider.GetOptions | The ITransferMetadataProvider class represents an interface that implements the transfer metadata process on the referenced connection. |
|
ITransferMetadataProvider.SaveMetadata | Saves metadata when transferring databases across instances. |
上層
備註
The following object types cannot be transferred:
All broker objects
All mail objects
Endpoint
ServerDdlTrigger
ExtendedStoredProcedure
FullTextCatalog
UserDefinedMessage
ApplicationRole
To get and set Transfer object properties, users can be a member of the public fixed server role.
To transfer data, users can be a member of the public fixed server role.
Thread Safety
此型別的任何公用靜態 (在 Microsoft Visual Basic 為共用) 成員具備多執行緒作業安全。並非所有的執行個體成員都是安全執行緒。
範例
執行緒安全性
這個型別的任何公用 static (在 Visual Basic 中為 Shared) 成員都是執行緒安全的。並不是所有的執行個體成員都保證可以用於所有的執行緒。