Use SQL Server everywhere to save offline data

SQL Server everywhere (ssev) is the next version of SQL Server mobile 2005 (SSM). The version number is 3.1, and the SSM version number is 3.0. From the changes in the version number, we can see that the SSM upgrade to ssev is basically not changed. The name changed from mobile to everywhere. It can be seen that ssev has changed mainly to extend the applicability of the platform, and of course it cannot be beyond the scope of Microsoft.

SSM supports Windows CE, Pocket PC, smartphone, and tablet PC, while ssev also adds support for desktop PC, pushing mobile databases to a new climax.

What does ssev support for desktop computers? Does the desktop already have SQL Server Express (SSE) and MS access?

Compared with MSDE, SSE is actually quite good. It not only enhances functions (such as XML support), but also facilitates deployment. SSE and ApplicationsProgramFor more information about deployment, see embedding SQL Server express into custom applications. Using SSE to save offline data of smart clients is a good choice. However, SSE is a little big for most people. Offline data caching requires a low level of database functionality. Normally, some reference data is cached, and the business data is usually too large to be cached on the client. The data synchronization between offline data and the primary database is exactly what smart clients need most. However, ssev can solve these problems well.

In fact, at the time of the release of SSM, mobile databases were already showing signs of extension to desktop computers. The last SSM version of SQL Server ce 2.0 (SSCE) only supports Pocket PC and Windows CE. SSM supports smartphone and tablet PC, in addition, you can operate SSM databases in the SQL Server Management Studio (SSMs) environment. That is to say, SSM databases can be edited on desktops from the beginning.

The use of ssev is almost the same as that of SSM (I have not found any difference), and the format of database files (*. SDF) is the same. By using the classes in the namespace system. Data. sqlserverce, You can implement remote data access (RDA) and merge replication, thus simplifying offline data synchronization on the Smart Client.

For details about ssev data caching for Smart Clients, refer to the two-course ppt and demo of Steve Lasker in tech. Ed 2006, USA.
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
(Message source)

In addition, Steve Lasker has a web cast which is similar to dev343 on teched. If you are interested, you can listen to it in English...
Smart Client: offline data synchronization and caching for Smart Clients
(Message source)

Ssev is being followed recently and will be reported later. If you are interested in ssev, visit the blog of Steve Lasker. There are many examples.CodeAnd video download. In addition, follow the blog of the ssev development team.

Here are FAQs about ssev:
Information about SQL Server everywhere edition (ssev)

The last version is the CTP version. Currently, only desktop computers are supported, and mobile devices are not supported.
Microsoft SQL Server 2005 everywhere edition CTP
SQL Server 2005 everywhere edition community technology preview books online