Considerations for Application Design and Deployment

The topics in this section describe several areas that you should consider when you are designing and deploying applications that use Sync Framework database providers.

Security Considerations

Describes several important approaches to help you secure data that is synchronized.

Tuning and Monitoring Performance

Describes how to optimize configuration, develop performance baselines, and monitor and tune to meet or exceed those baselines.

Database Objects Supported by Sync Framework

Describes the types of objects that you can synchronize.

Selecting an Appropriate Primary Key for a Distributed Environment

Describes several types of keys that can be used for tables involved in synchronization, including identities and GUIDs.

Working with Table Schemas

Describes the types of schema changes that are supported in a peer-to-peer synchronization scenario.

Data Type Mapping and Considerations

Describes how data types are mapped between ADO.NET and SQL Server Compact, and includes information about data types that require special attention.

Backing Up and Restoring a Database

Describes how to ensure that changes are synchronized correctly after a server database is restored from a backup.

Database Connections

Describes how connections are made during synchronization.

Upgrading SQL Server Compact

Discusses upgrade of an existing SQL Server Compact database when Sync Framework is upgraded.

Tracing the Synchronization Process

Shows how to obtain tracing information during synchronization to help diagnose errors.