Share via

  • Article

Publication Properties, FTP Snapshot and Internet

For snapshot and transactional publications, and merge publications on SQL Server 2000, this page is entitled FTP Snapshot. For merge publications on SQL Server 2005 and later versions, it is entitled FTP Snapshot and Internet. This page allows you to:

  • Set properties for delivering the snapshot through File Transfer Protocol (FTP). For more information, see Transferring Snapshots Through FTP. To use FTP for snapshot delivery you must set up an FTP server. See the Microsoft Windows documentation for more information.

    Note

    Changes to any FTP settings require a new snapshot to be generated.

  • Set properties for Web synchronization for merge replication on SQL Server 2005 and later versions, which allows subscriptions to be synchronized over HTTPS (secure hypertext transfer protocol). To use Web synchronization, you must configure an Microsoft Internet Information Services (IIS) server. For more information, see Web Synchronization for Merge Replication.

Options

  • Access snapshot files via FTP
    Select Allow Subscribers to download snapshot files using FTP (File Transfer Protocol), and specify FTP server name, Port number, Path from the FTP root folder, Login, and Password, to allow Subscribers to use FTP for snapshot delivery.

    This option allows Subscribers to use FTP to retrieve snapshot files, but does not require them to do so. If you select this option, the New Subscription Wizard defaults to having the Subscriber retrieve snapshot files through FTP. To change the setting, use the Subscription Properties dialog box. If you allow Subscribers to access the snapshot files through FTP, specify the FTP folder as the location for snapshot files on the Snapshot page of the Publication Properties dialog box. Doing so will cause the Snapshot Agent to update the files in the FTP folder automatically when a new snapshot is generated. If the location is not set to the FTP folder, you will have to update the files manually when new snapshots are generated. For more information, see How to: Deliver a Snapshot Through FTP (SQL Server Management Studio).

  • Web Synchronization
    Microsoft SQL Server 2005 and later versions only. Merge replication only. Select Allow Subscribers to synchronize by connecting to a Web server, and specify a Web server address to allow merge Subscribers to use Web synchronization. The Web server must use Secure Sockets Layer (SSL), and the Web address must be fully qualified, such as https://server.domain.com/synchronize. For more information, see Configuring Web Synchronization.