TransferSqlServerObjectsTask.UseCollation Property

Gets or sets a Boolean indicating whether the transfer should use collations.

네임스페이스: Microsoft.SqlServer.Dts.Tasks.TransferSqlServerObjectsTask
어셈블리: Microsoft.SqlServer.TransferSqlServerObjectsTask (in microsoft.sqlserver.transfersqlserverobjectstask.dll)

구문

‘선언
Public Property UseCollation As Boolean

public bool UseCollation { get; set; }

public:
virtual property bool UseCollation {
    bool get () sealed;
    void set (bool value) sealed;
}

/** @property */
public final boolean get_UseCollation ()

/** @property */
public final void set_UseCollation (boolean value)

public final function get UseCollation () : boolean

public final function set UseCollation (value : boolean)

속성 값

true if the transfer includes the collation; false if the collation at the destination is used.

주의

If UseCollation is set to true, column-level collation settings are maintained when transferring data between computers running an instance of SQL Server 2000 or later if the code pages are the same on both servers. When data is transferred to a computer running an instance of SQL Server 2000, and the destination instance uses a different code page than the source, all collation settings at the source server are automatically translated to the code page of the destination server.

When data is transferred to a computer running an instance of SQL Server version 7.0 or earlier, all collation settings at the source server are automatically translated to the code page of the destination server if the code pages settings are different. The source database column-level collation is translated accordingly.

If UseCollation is set to false, direct data transfer is performed if the code pages are the same on both servers. If the code pages are different, the data is translated from the code page of the source to the code page of the destination. If both computers are running SQL Server 2000 and the source and destination databases are using different code pages, data might be translated to the incorrect code page setting, depending on whether the column is using the default or a nondefault collation.

[!참고] Setting UseCollation to true can result in a decrease in performance if the data contains non-Unicode data types such as text or varchar. Performance can also be affected by the number of tables, columns, and rows in the source database.

스레드 보안

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

플랫폼

개발 플랫폼

지원되는 플랫폼 목록은 SQL Server 2005 설치를 위한 하드웨어 및 소프트웨어 요구 사항을 참조하십시오.

대상 플랫폼

지원되는 플랫폼 목록은 SQL Server 2005 설치를 위한 하드웨어 및 소프트웨어 요구 사항을 참조하십시오.

참고 항목

참조

TransferSqlServerObjectsTask Class
TransferSqlServerObjectsTask Members
Microsoft.SqlServer.Dts.Tasks.TransferSqlServerObjectsTask Namespace