FTPAddress Property

后续版本的 Microsoft SQL Server 将删除该功能。请避免在新的开发工作中使用该功能，并着手修改当前还在使用该功能的应用程序。

The FTPAddress property exposes the address of a File Transfer Protocol (FTP) server that maintains synchronization images of a Microsoft SQL Server publication.

语法

object
.FTPAddress [=value ]

Parts

• object
  An expression that evaluates to an object in the Applies To list

• value
  A string that identifies a server enabled for FTP

Data Type

String

Modifiable

Read/write

Prototype (C/C++)

HRESULT GetFTPAddress(SQLDMO_LPBSTR pRetVal);
HRESULT SetFTPAddress(SQLDMO_LPCSTR NewValue);

备注

SQL Server replication can use FTP to transfer synchronization images of publication schema and data. Use the FTPAddress, FTPPort, FTPLogin, and FTPPassword properties to enable use of FTP for synchronization.

Applications should use the MergePublication2 or TransPublication2 objects when setting the FTPAddress property. The FTPAddress property remains a property of the TransPullSubscription and MergePullSubscription objects to maintain backward compatibility.

注意：
If an application sets FTPAddress with the MergePublication2 or TransPublication2 object after the initial snapshot has been created, a new snapshot must be generated. Snapshots are applied when the next scheduled snapshot agent runs.

Applies To:

请参阅

参考

FTPLogin Property
FTPPassword Property
FTPPort Property
FTPSubdirectory Property

帮助和信息

获取 SQL Server 2005 帮助