Microsoft sync framework 2.1 software development kit (SDK)

Sync framework 2.1 introduces new features that allow you to synchronize SQL Server or SQL Server compact databases on your computer with SQL azure databases. This release also introduces parameter-based filtering and the ability to delete synchronization scopes and templates from databases, and enhances performance to accelerate and simplify the synchronization process.
SQL azure Synchronization
With sync framework 2.1, you can extend your data scope to the Web by leveraging the Windows azure platform and the SQL azure database. By synchronizing the SQL Server database deployed inside your enterprise with SQL Azure, You can provide some or all of your data on the web, you do not need to provide the customer with a connection to access your internal deployed SQL Server database. After the SQL azure database is configured for synchronization, you can take the data offline and store it in the client database (such as SQL Server compact or SQL Server express, in this way, your applications can work in a disconnected state, and your customers can work normally without a stable network connection. Changes to field data can be synchronized back to the SQL azure database, and finally back to the SQL Server database deployed internally. Sync framework 2.1 also provides some features that allow you to interact well with the Windows azure and SQL azure sharing environments. These features include performance enhancement, the ability to define the maximum Transaction size to avoid suspension, and the ability to automatically retry a transaction after Windows azure suspends a transaction.
The sync framework allows you to flexibly create the structure of the synchronization community, but using a 2-layer architecture or N-layer architecture is two typical methods.

• 2-layer architecture: the sync framework runs on a local computer and uses the sqlsyncprovider object to directly connect to the SQL azure database without passing through the intermediate layer or web server, such as Internet Information Services (IIS ).
• Layer-N architecture: run the sync framework database provider in the Windows azure hosting service and communicate with the proxy provider running on the local computer.

Batch application changes
Sync framework 2.1 uses the table value parameter functions of SQL Server 2008 and SQL azure to apply multiple insert, update, and delete operations by calling a single stored procedure, instead of requiring the stored procedure to call each change of the application. This greatly improves the performance of these operations and reduces the number of round-trips between the client and the server. By default, large-capacity processes are created when you set SQL Server 2008 or SQL azure databases.
Parameter-Based Filtering
Sync framework 2.1 allows you to create parameter-based filters to control which data to be synchronized. Parameter-based filters are especially useful when you want to filter data based on fields with different values (such as user ID or region) or based on combinations of two or more fields. Create a parameter-based filter in two steps. First, define the filter and scope template. Then, create a filtered scope with specific values for the filter parameters. This two-step process has the following advantages:

• Easy to set. The filter template only needs to be defined once. Creating a filter template is the only operation that requires the permission to create a stored procedure on the database server. This step is usually performed by the database administrator.
• Easy to subscribe. The client specifies the parameter value to be created and subscribes to the filtered scope as needed. This step only requires the permission to insert rows in the synchronization table of the database server. This step can be performed by the user.
• Easy to maintain. Even when merging several parameters and creating many filtered scopes, maintenance is easy because a single parameter-based process is used to enumerate changes.

Delete scopes and templates
The sqlsyncscopedeprovisioning and sqlcesyncscopedeprovisioning classes are added to sync framework 2.1. These classes allow you to easily Delete synchronization elements from the databases you have set for synchronization. By using these classes, you can delete scopes, filter templates, and associated metadata tables, triggers, and stored procedures from the database.
Update metadata format
The metadata format of the database provider is changed in sync framework 2.1. The new metadata format is incompatible with earlier versions of the database provider. The operation to upgrade to the new metadata format cannot be undone. When you try to use an earlier version of the database provider to synchronize a database in the 2.1 format, the sync framework will cause an exception. However, the sqlsyncprovider class in sync framework 2.1 checks whether the metadata is in the 2.0 or 2.1 format and operates in backward compatible mode to synchronize databases that contain the metadata in the 2.0 format. The sync framework can synchronize databases in the 2.0 format with those in the 2.0 or 2.1 format. Therefore, you do not need to upgrade and synchronize all databases in the Community at the same time. For example, in the n-layer architecture, you can upgrade the server sync framework component and database metadata format and continue to synchronize with clients that use sync Framework 2.0. The client can wait until the upgrade is convenient.
SQL Server compact 3.5 SP2 compatibility
The sync framework 2.1 sqlcesyncprovider database provider uses SQL Server compact 3.5 SP2. The existing SQL Server compact database will be automatically upgraded when the sync framework is connected to them. Another new feature is that SQL Server compact 3.5 SP2 provides a change tracking API that allows you to configure, enable, and disable change tracking for tables, it also supports access to change tracking data for this table. You can download SQL Server compact 3.5 SP2 from here.
Sync framework 2.1 re-release package
To download the Microsoft sync framework 2.1 redistributable package, instead of the SDK package, click the link: Microsoft sync framework 2.1 redistributable package

: Http://www.microsoft.com/downloads/details.aspx? Displaylang = ZH-CN & familyid = ee6af141-79d0-4351-a4a0-ea89bb29dcf5