SQL Server 2008 R2

Microsoft SQL Server Compact 3.5 supports three methods of connecting to and exchanging data with a SQL Server database: remote data access (RDA), merge replication, and Sync Services.



Connectivity Overview

Describes the options to connect SQL Server Compact 3.5 to SQL Server, and security and optimization features.

Introducing Merge Replication

Describes merge replication.

Introducing Remote Data Access

Describes RDA.

Microsoft Synchronization Services for ADO.NET

Describes a new synchronization technology for SQL Server Compact 3.5.

Comparing Synchronization Technologies

Outlines key features of available synchronization technologies in SQL Server Compact 3.5.

Comparing Remote Data Access and Merge Replication

Compares the features of merge replication and RDA.

Configuring and Securing the Server Environment

Provides information about configuring security while connecting SQL Server Compact 3.5 with SQL Server.

Using Remote Data Access (RDA)

Provides details about how to implement RDA in an application.

Using Merge Replication

Describes merge replication functionality in SQL Server Compact 3.5 and provides implementation details for an application.