Classe Transfer
The Transfer object is a tool object that provides programmatic control over copying of schemas and data to other instances of SQL Server.
Spazio dei nomi: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.SmoExtended (in Microsoft.SqlServer.SmoExtended.dll)
Sintassi
'Dichiarazione
Public Class Transfer _
Implements ITransferMetadataProvider
'Utilizzo
Dim instance As Transfer
public class Transfer : ITransferMetadataProvider
public ref class Transfer : ITransferMetadataProvider
type Transfer =
class
interface ITransferMetadataProvider
end
public class Transfer implements ITransferMetadataProvider
Osservazioni
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
Tutti i membri statici pubblici (Shared in Microsoft Visual Basic) di questo tipo sono sicuri per le operazioni a thread multipli. Non è invece garantita la sicurezza dei membri dell'istanza.
Gerarchia di ereditarietà
System. . :: . .Object
Microsoft.SqlServer.Management.Smo..::..Transfer
Thread Safety
Tutti i membri pubblici static (Shared in Visual Basic) di questo tipo sono thread safe. I membri di istanza non hanno garanzia di essere thread safe.