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.

In This Section

Tuning and Monitoring Performance

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

Security Considerations

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

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, and how Sync Framework handles differences between server and client schemas.

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.

Deploying and Versioning Applications

Describes how applications are deployed and initialized, and how to handle schema changes and multiple application versions.

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.

See Also