Configuring an FTP Snapshot Folder
If Microsoft SQL Server Compact 3.5 (SQL Server Compact 3.5) is subscribing to a SQL Server 2008 publication, SQL Server Compact 3.5 can retrieve the snapshot files through a shared (UNC) snapshot folder or through an FTP virtual directory. The FTP virtual directory is created in Microsoft Internet Information Services (IIS) like any other FTP virtual directory. The Publisher and Subscriber are then configured to use the FTP virtual directory.
Requirements for Using an FTP Snapshot Folder
To use an FTP site for your snapshot folder, the following conditions must be met:
- The Publisher must be running SQL Server 2008.
- An FTP server must be enabled and configured to point to the C:\Program Files\Microsoft SQL Server\MSSQL\Repldata\Ftp directory.
For more information about configuring an FTP server, see the Internet Information Services (IIS) documentation. - The publication is configured to use an FTP snapshot:
- The @enable_for_internet property of the sp_addmergepublication is set to true.
For more information, see "Transferring Snapshots Through FTP" in SQL Server Books Online.
- The @enable_for_internet property of the sp_addmergepublication is set to true.
- The SQL Server Compact 3.5 subscriber is configured to use the FTP site.
- The snapshotTransferType property is set to FTP (instead of UNC).
See Also
Concepts
Configuring the Snapshot Folder
Sharing and Securing the Snapshot Folder
Monitoring the Snapshot Agent