Chapter 8. Using SQL Server in a Mobile Environment

Team-Fly

---

  

	eMbedded Visual Basic: Windows CE and Pocket PC Mobile Applications By Chris Tacke, Timothy Bassett
	Table of Contents

---

IN THIS CHAPTER

• Installing and Configuring SQL Server CE on Your Server

• Installing and Configuring SQL Server CE on Your Device or Emulator

• Establishing Connectivity for SQL Server CE

• Understanding the SQL Server CE Object Model

• Using SQL Server CE Data

• Using Replication with SQL Server CE

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:

• SQL Server CE can subscribe to publications from Microsoft SQL Server 2000.

• SQL Server CE provides a Remote Data Access (RDA) technology that allows dynamic access to remote data.

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

---

Team-Fly

Top