Saving offline data with SQL Server everywhere

SQL Server Everywhere (SSEV) is the next version of SQL Server Mobile (SSM), the version number is 3.1, and the SSM version number is 3.0. From the change of version number can be seen, SSM upgrade to Ssev function basically will not have any change. The name changed from Mobile to everywhere, it can be seen that the changes in Ssev mainly extend the applicability of the platform, of course, it can not exceed the scope of Microsoft.

The SSM supports Windows CE, Pocket pc, Smartphone, and Tablet PCs, while Ssev also adds support for the Desktop PC, once again pushing the mobile database to a new climax.

What does Ssev support for desktop computers mean? Isn't the desktop already with SQL Server Express (SSE) and MS Access?

As opposed to MSDE, SSE is actually very good, it is not only enhanced functionality (such as the support of XML), deployment is also a lot easier. For knowledge about SSE deployment with applications, refer to embedding SQL Server Express into Custom applications. It is a good choice to use SSE to keep offline data from smart clients. But SSE for most people, still a bit big. To realize the caching of off-line data, the function requirement of database is low. Usually caching is some reference data, business data generally change too much, not in the client cache. And the data synchronization between the off-line data and the main database is exactly what the smart client needs most. However, Ssev can solve these problems well.

In fact, when the SSM release, Mobile database has been to the desktop computer extensions. The previous version of the SSM, SQL Server CE 2.0 (SSCE), only supported Pocket PCs and Windows CE,SSM increased support for Smartphone and Tablet PCs, plus support for SQL Server Manage ment Studio (SSMS) operates the SSM database in the environment. That is to say, from the SSM to support the SSM database editing on the desktop.

The use of Ssev is almost as much as the SSM (I haven't found any difference anyway), and the database file (*.SDF) is in the same format. By using the classes below the System.Data.SqlServerCe namespace, Remote data Access (RDA) and Merge Replication can be implemented to simplify the synchronization of offline data for smart clients.

For Ssev data caching for smart clients, you can refer to the PPT and demo of the two Lessons Steve.lasker in Tech.ed 2006 in the United States.

Slides:

DEV351 developing local and Mobile Data Solutions with SQL Server everywhere Edition

DEV343 Offline Data synchronization and Caching with SQL Server everywhere Edition

Demos:

Database Viewer

Synchronizing SQL Server everywhere with Remote Data Access (RDA)

SqlCeResultSet, an updateable, scrollable cursor

(Source of information)

In addition, Steve.lasker also has a Web Cast with his TechED on the DEV343 that class content almost the same, we are interested can go to listen to, but English, hehe ...

Smart Client:offline Data synchronization and Caching for Smart Clients

(Source of information)

Recently in the attention of Ssev, there will be time to continue to report its news. Friends interested in Ssev can go to Steve.lasker's blog and have a lot of sample code and video downloads. In addition Ssev development team Blog also pay attention to it.

Here's a Ssev FAQ:

Information about SQL Server everywhere Edition (Ssev)

Finally, the CTP version of the download address, currently only support desktop computers, do not support mobile devices.

Microsoft SQL Server Everywhere Edition CTP

SQL Server everywhere Edition Community Technology Preview Books Online