If Microsoft SQL Server Compact 3.5 is subscribing to a SQL Server 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.
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 SQL Server Compact 3.5 subscriber is configured to use the FTP site.
- The snapshotTransferType property is set to FTP (instead of UNC).
The information in this topic applies to supported versions of SQL Server; for more information, see Hardware and Software Requirements.
Concepts
Configuring the Snapshot Folder