Publishing Data Over the Internet Using TCP/IP and FTP

SQL Replication

Replication

Publishing Data Over the Internet Using TCP/IP and FTP

Microsoft® SQL Server™ 2000 can use the TCP/IP Sockets or the Multiprotocol Net-Libraries over TCP/IP to establish an ODBC connection between the Publisher or Distributor and the Subscriber. You can then configure the publication and pull subscriptions or anonymous subscriptions to access the FTP site where the data will be replicated.

Configuring your application for Internet publishing requires:

  • Configuring a Publisher or Distributor to listen on TCP/IP.

  • Configuring a publication to allow Subscribers to retrieve snapshots using FTP.

  • Creating a subscription to use FTP for retrieving snapshots.

  • Configuring a subscription agent to use TCP/IP.