Share via


Managing Connectivity (SQL Server Compact Edition)

Microsoft SQL Server 2005 Compact Edition (SQL Server Compact Edition) supports two methods of connecting to and exchanging data with a SQL Server database: remote data access (RDA) and merge replication.

Topic Description

Connectivity Overview

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

Introducing Merge Replication

Describes merge replication.

Introducing Remote Data Access

Describes RDA.

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 Edition 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 Edition and provides implementation details for an application.