Transfer 클래스

The Transfer object is a tool object that provides programmatic control over copying of schemas and data to other instances of SQL Server.

네임스페이스: Microsoft.SqlServer.Management.Smo
어셈블리: Microsoft.SqlServer.SmoExtended.dll의 Microsoft.SqlServer.SmoExtended

구문

‘선언
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

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:

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.

이 유형의 모든 public static(Microsoft Visual Basic의 경우 공유) 멤버는 다중 스레드 작업을 수행하기에 안전합니다. 인스턴스 멤버는 스레드로부터의 안전성이 보장되지 않습니다.

System. . :: . .Object
Microsoft.SqlServer.Management.Smo..::..Transfer

이 형식의 모든 공용 static(Visual Basic에서는 Shared) 멤버는 스레드로부터 안전합니다. 인스턴스 멤버는 스레드로부터의 안전성이 보장되지 않습니다.