共用方式為


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..::..Transfer

命名空間:  Microsoft.SqlServer.Management.Smo
組件:  Microsoft.SqlServer.SmoExtended (在 Microsoft.SqlServer.SmoExtended.dll 中)

語法

'宣告
Public Class Transfer _
    Implements ITransferMetadataProvider
'用途
Dim instance As Transfer
public class Transfer : ITransferMetadataProvider
public ref class Transfer : ITransferMetadataProvider
type Transfer =  
    class
        interface ITransferMetadataProvider
    end
public class Transfer implements ITransferMetadataProvider

Transfer 型別公開下列成員。

建構函式

  名稱 說明
公用方法 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.

上層

屬性

  名稱 說明
公用屬性 CopyAllDatabaseTriggers Gets or sets the Boolean property value that specifies whether all the 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 SQL Server defaults are copied from the source database to the target database in the transfer operation.
公用屬性 CopyAllFullTextCatalogs Gets or sets the Boolean property value that specifies whether all the SQL Server Full-Text catalogs are copied from the source database to the target database in the transfer operation.
公用屬性 CopyAllFullTextStopLists Gets or sets the Boolean property value that specifies whether all the SQL Server full-text stop lists 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 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 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 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 SQL Server partition schemes are copied from the source database to the target database in the transfer operation.
公用屬性 CopyAllPlanGuides Gets or sets the Boolean property value that specifies whether all the SQL Server plan guides 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 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 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 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 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 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 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 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 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 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 SQL Server user-defined functions are copied from the source database to the target database in the transfer operation.
公用屬性 CopyAllUserDefinedTableTypes Gets or sets the Boolean property value that specifies whether all the SQL Server user-defined table types 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 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 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 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 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.
公用屬性 DatabaseFileMappings Gets or sets properties that are associated with flat file destination based on a DatabaseFileMappingsDictionary object.
公用屬性 DestinationDatabase Gets or sets the database that is the destination of the transfer operation.
公用屬性 DestinationLogin Gets or sets the logon for the instance of SQL Server to which the destination database belongs.
公用屬性 DestinationLoginSecure Gets or sets the Boolean property that specifies whether the instance of SQL Server that contains the destination database is enabled for Windows Authentication or not.
公用屬性 DestinationPassword Gets or sets the logon password for the instance of SQL Server to which the destination database belongs.
公用屬性 DestinationServer Gets or sets the instance of 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.
公用屬性 PreserveDbo Gets or sets a Boolean value that specifies whether DBO ownerships are retained through the transfer process.
公用屬性 PreserveLogins Gets or sets the Boolean property that specifies whether to preserve logins in 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 Gets or sets the path to where the database files will be copied.
公用屬性 TargetLogFilePath Gets or sets the path to where the database files will be copied.
公用屬性 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.

上層

方法

  名稱 說明
公用方法 EnumObjects Returns an enumerated list of Uniform Resource Name (URN) values that represent the objects included in the transfer operation.
公用方法 EnumScriptTransfer Creates a Transact-SQL command batch script used to transfer database objects or database objects and data to another database instance.
公用方法 Equals (繼承自 Object。)
受保護的方法 Finalize (繼承自 Object。)
公用方法 GetHashCode (繼承自 Object。)
公用方法 GetTransferProvider Returns the data transfer provider interface.
公用方法 GetType (繼承自 Object。)
受保護的方法 MemberwiseClone (繼承自 Object。)
受保護的方法靜態成員 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.
公用方法 ToString (繼承自 Object。)
公用方法 TransferData Transfers data as specified by the Transfer object.

上層

事件

  名稱 說明
公用事件 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.

上層

明確 繼承 實作

  名稱 說明
明確介面實作私用方法 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.

上層

備註

There are some limitations when transferring a database to a server instance that is running SQL Server 2000: 

  • If the database has a schema for which there is no corresponding user on the target SQL Server 2000 server instance, it cannot be transferred. In this case, you have to create a user who has a name that is the same as the name of the schema.

  • Any object that uses the following data types cannot be transferred:

    • SqlDataType.Xml

    • SqlDataType.VarCharMax

    • SqlDataType.NVarCharMax

    • SqlDataType.VarBinaryMax

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) 成員都是執行緒安全的。並不是所有的執行個體成員都保證可以用於所有的執行緒。