eMbedded Visual Basic®: Windows® CE and Pocket PC Mobile Applications By
Chris Tacke, Timothy Bassett | | Table of Contents |
|
|
Chapter 8. Using SQL Server in a Mobile Environment
IN THIS CHAPTER
SQL Server CE is the first Microsoft product for enterprise data access for Windows CE. SQL Server CE provides a high-performance data engine that runs on all Windows CE platforms. The SQL Server CE provides access to both local and remote data. Local data is accessed via ADOCE, the same as Pocket Access data. This local data can be defined locally or retrieved from a remote source. In other words, you can use SQL Server CE just as you would Pocket Access. But, the power of SQL Server CE comes from the capability to communicate with a Microsoft SQL Server to exchange data. SQL Server CE can pull data to the device and push updates back to the enterprise SQL Server. Remote data is accessed in one of two ways using SQL Server CE:
Other features SQL Server CE provides over Pocket Access include higher performance, more robustness, encryption, and security. In this chapter, you will learn about The SQL Server CE object, replication, and remote data access models How to install and configure SQL Server CE on your server, as well as on your Pocket PC or emulator How to choose between SQL Server CE merge replication and Remote Data Access How to create a publication for replication to a Windows CE device How to subscribe to and use a publication from Windows CE in the sample application
|