Transfer-Klasse
The Transfer object is a tool object that provides programmatic control over copying of schemas and data to other instances of SQL Server.
Vererbungshierarchie
System.Object
Microsoft.SqlServer.Management.Smo.TransferBase
Microsoft.SqlServer.Management.Smo.DataTransferBase
Microsoft.SqlServer.Management.Smo.Transfer
Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.SmoExtended (in Microsoft.SqlServer.SmoExtended.dll)
Syntax
'Declaration
Public Class Transfer _
Inherits DataTransferBase _
Implements ITransferMetadataProvider
'Usage
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
Der Transfer-Typ macht folgende Elemente verfügbar.
Konstruktoren
| Name | Beschreibung | |
|---|---|---|
.gif "Öffentliche Methode") |
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. |
Zum Anfang
Eigenschaften
| Name | Beschreibung | |
|---|---|---|
.gif "Öffentliche Eigenschaft") |
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. (Geerbt von 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. (Geerbt von 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. (Geerbt von 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. (Geerbt von 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. (Geerbt von 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. (Geerbt von 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. (Geerbt von 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. (Geerbt von 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. (Geerbt von 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. (Geerbt von 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. (Geerbt von 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. (Geerbt von 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. (Geerbt von 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. (Geerbt von 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. (Geerbt von 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. (Geerbt von 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. (Geerbt von 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. (Geerbt von 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. (Geerbt von 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. (Geerbt von 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. (Geerbt von 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. (Geerbt von 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. (Geerbt von 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. (Geerbt von 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. (Geerbt von 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. (Geerbt von 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. (Geerbt von 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. (Geerbt von TransferBase.) |
|
CreateTargetDatabase | Gets or sets a value that indicates whether the target database is created in the transfer operation. (Geerbt von TransferBase.) |
|
Database | Gets or sets the database from which schema or data is to be transferred to the target location. (Geerbt von TransferBase.) |
|
DatabaseFileMappings | Gets or sets the properties that are associated with flat file destination based on a dictionary. (Geerbt von TransferBase.) |
|
DestinationDatabase | Gets or sets the database that is the destination of the transfer operation. (Geerbt von TransferBase.) |
|
DestinationLogin | Gets or sets the logon for the instance of SQL Server to which the destination database belongs. (Geerbt von 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. (Geerbt von TransferBase.) |
|
DestinationPassword | Gets or sets the logon password for the instance of SQL Server to which the destination database belongs. (Geerbt von TransferBase.) |
|
DestinationServer | Gets or sets the instance of SQL Server that owns the database that is the destination of the transfer operation. (Geerbt von TransferBase.) |
|
DestinationTranslateChar | Gets or sets a value that indicates whether the transfer operation translates the code page for characters on the destination database. (Geerbt von TransferBase.) |
|
DropDestinationObjectsFirst | Gets or sets a value that indicates whether to drop the objects in the destination database before the transfer operation. (Geerbt von TransferBase.) |
|
ObjectList | Gets or sets the objects copied from the source to destination in the transfer operation. (Geerbt von TransferBase.) |
|
Options | Gets or sets the options for the transfer operation. (Geerbt von TransferBase.) |
|
PrefetchObjects | Gets or sets a value that indicates whether to prefetch the objects before the transfer operation. (Geerbt von TransferBase.) |
|
PreserveDbo | Gets or sets a value that indicates whether DBO ownerships are retained through the transfer process. (Geerbt von TransferBase.) |
|
PreserveLogins | Gets or sets a value that indicates whether to preserve logins in the transfer operation. (Geerbt von TransferBase.) |
.gif "Geschützte Eigenschaft") |
Scripter | Gets the scripter for the transfer operation. (Geerbt von TransferBase.) |
|
SourceTranslateChar | Gets or sets a value that indicates whether the transfer operation translates the code page for characters on the source database. (Geerbt von TransferBase.) |
|
TargetDatabaseFilePath | Gets or sets the path to where the database files will be copied. (Geerbt von TransferBase.) |
|
TargetLogFilePath | Gets or sets the path to where the log files will be copied. (Geerbt von 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. (Geerbt von TransferBase.) |
Zum Anfang
Methoden
| Name | Beschreibung | |
|---|---|---|
|
EnumObjects | Returns an enumerated list of Uniform Resource Name (URN) values that represent the objects included in the transfer operation. (Geerbt von TransferBase.) |
|
EnumScriptTransfer | Creates a Transact-SQL command batch script used to transfer database objects or database objects and data to another database instance. (Geerbt von TransferBase.) |
|
Equals | (Geerbt von Object.) |
.gif "Geschützte Methode") |
Finalize | (Geerbt von Object.) |
|
GetHashCode | (Geerbt von Object.) |
|
GetTransferProvider | For internal use only. Throws a System.NotSupportedException if invoked by a caller. |
|
GetType | (Geerbt von Object.) |
|
MemberwiseClone | (Geerbt von Object.) |
.gif "Statisches Element") |
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. (Geerbt von TransferBase.) |
|
SetTargetServerInfo | Sets the target server version based on the SQL Server version. (Geerbt von TransferBase.) |
|
ToString | (Geerbt von Object.) |
|
TransferData | Transfers data as specified by the Transfer object. |
Zum Anfang
Ereignisse
| Name | Beschreibung | |
|---|---|---|
.gif "Öffentliches Ereignis") |
DataTransferEvent | Reports that data has been transferred. |
|
DiscoveryProgress | Marks the progress of the discovery process. (Geerbt von TransferBase.) |
|
ScriptingError | Reports that an error occurred during the scripting process. (Geerbt von TransferBase.) |
|
ScriptingProgress | Marks the progress of the scripting process. (Geerbt von TransferBase.) |
Zum Anfang
Explizite Schnittstellenimplementierungen
| Name | Beschreibung | |
|---|---|---|
.gif "Explizite Schnittstellenimplementierung") .gif "Private Methode") |
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. |
Zum Anfang
Hinweise
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
Alle öffentlichen, statischen Elemente dieses Typs (Shared in Microsoft Visual Basic) sind für Vorgänge mit mehreren Threads sicher. Bei Instanzmembern ist die Threadsicherheit nicht gewährleistet.
Beispiele
Threadsicherheit
Alle öffentlichen static (Shared in Visual Basic)-Elemente dieses Typs sind Threadsicher. Für Instanzelemente wird die Threadsicherheit nicht gewährleistet.