Share via


To exchange data with SQL Server, you must first install the software components required for use with Microsoft SQL Server Compact 3.5. For more information, see Installing a Server Environment.

After you install the necessary components, you must configure the appropriate security and connectivity options before any data can be exchanged by using replication between SQL Server and SQL Server Compact 3.5.

Steps to Configure SQL Server for Replication

  1. Create a Publication. For more information, see Creating the Publication.

  2. Set the database and publication access. For more information, see Securing the Publication.

  3. Configure the snapshot folder. For more information, see Configuring the Snapshot Folder.

Concepts

Installing a Server Environment

Subscribing to Publications (SQL Server Compact)

Synchronizing Data (SQL Server Compact)

Monitoring Replication (SQL Server Compact)