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.