Microsoft SQL Server 2000 Windows CE Edition: Overview and Programming Syed N' Yousuf PSS Developer

1
Microsoft SQL Server 2000 Windows CE
EditionOverview and ProgrammingSyed N.
YousufPSS Developer Support Microsoft
Corporation
2
Windows CE ApplicationsWhy Care?
Manufacturing problem?
Fast turn around time to fix the problem
Manage the issues
3
Sample Application
4
Windows CE Data Access Tools

• eVB / eVC 3.0 IDE
• ADOCE 3.1
• OLE DB CE
• Similar to desktop development

eVB 3.0
eVC 3.0
ADO CE v3.1
Active X Objects
OLEDB CE
SQL Server For CE
OLEDB
QP/Cursor Engine/ES
OLEDB
Storage Engine / Repl Tracking
5
SQL Server 2000 Windows CE Edition!

• Upward compatibility with Microsoft SQL Server
• Right footprint size for devices
• OS support for Microsoft Windows CE 2.11 or
  higher

6
SQL Server 2000Windows CE Edition!

• Windows CE platforms Palm-size PC, H/PC Pro
  (Handheld PC Pro), and Pocket PC
• Exceptional performance in enterprise mobile data
  management
• Substantially faster than CEDB

7
SQL Server CE vs. CEDB

• SQL Server CE addresses missing features in CEDB
• Query processor enhancements
• Storage engine enhancements
• Performance
• Replication

8
Hardware / Software Requirements

• Development system, 30 MB
• Windows CE device, 1 - 3 MB
• Platform CE OS
• Handheld PC Pro (H/PC Pro) 2.11 or later
• Palm-size PC (P/PC) 2.11 or later
• Pocket PC 3.0 or later

9
OLE DB CE

• OLE DB provider is in-proc to SQL Server CE
• ADOCE 3.1 is a consumer
• Data manipulation using ADO in eVB or OLE DB in
  eVC
• ProviderMicrosoft.SQLSERVER.OLEDB.CE.1.0

10
Database Feature Set

• Up to 32 indexes per table
• Multi-column indexes
• Referential integrity
• Sub-selects (IN)
• Defaults
• Inner/outer joins
• Single-file database

11
Database Feature Set

• Null support
• Unicode support
• Transactions
• Data types
• Having/group by
• Index seek
• Identity attribute
• Local security and encryption

12
Features Query Processor

• Constraints
• Expression service
• Cursors

13
Installing SQL Server CE

• eMbedded Visual Tools 3.0
• SDKs HPC Pro, Palm-size PC, Pocket PC
• ActiveSync 3.1
• Need administrator access
• Development tools installation (includes (ADOCE,
  ADOXCE, OLEDBCE)
• Server tools installation

14
Developing an eVB Application

• Microsoft CE SQL Server Control 1.0
• Microsoft CE ADO Control 3.1.
• Microsoft CE ADO Ext. 3.1 (optional)
• Ssceconsts.bas
• Adoconsts.bas
• eVB will install SQL Server CE on the device

15
Configure TCP/IP Transport
16
SQL Server CE Query Analyzer
17
Connectivity SolutionsRemote Data Access

• Eliminate desktop for connectivity
• Access to versions of SQL Server 6.5 or higher
• Download to device and disconnect
• Disconnected tracking capability

18
Connectivity SolutionsRemote Data Access Methods

• Pull
• Brings data from server to device
• Data selected via SQL statement
• Creates and populates local table
• Allows for tracked and untracked data
• Push
• Sends modified data to server
• Submit SQL
• Pass SQL DML statement

19
Remote Data Access Architecture
eVB 3.0
eVC 3.0
ADO CE v3.1
SQL CE ActiveX Objects
OLEDB CE
SQL Server 2000 Windows CE Edition
OLEDB
OLEDB
IIS
Server Agent Replication RDA
QP/Cursor Engine/ES
Client Agent Replication RDA
HTTP
Storage Engine
CLIENT
SERVER
20
Replication to SQL Server 2000

• Read only / download
• Data captureand upload
• Replicate, update, synchronize

21
SQL Server CE Merge Replication Overview

• Publisher makes data available
• Subscribers receive replicated data
• Publishers and subscribers can update data
  whenever they wish
• Updates are periodically exchanged
• Conflicting updates are resolved

22
SQL Server CE Merge Replication

• DBA creates the publication
• Merge replication processes
• Snapshot Agent
• Merge Agent

23
Steps in SQL Server CE Replication

• Create a SQL publication
• Write a Win CE application
• Programmatically create a subscription
• Read and update local data
• Programmatically initiate merge
• Resolve and log conflicts

24
Connectivity Replication
SERVER
CLIENT
IIS
SQL Server Reconciler
SQL Server ReplicationProvider
App
SQLServer
SSCEServerAgent
SSCEClientAgent
SSCE ReplicationProvider
SSCEDB
.IN
.OUT
25
Resources

• Books online
• SQL Server CE Support FAQ
• http//support.microsoft.com/support/sql/content/s
  qlce/sqlcefaq.asp
• http//www.microsoft.com/windows/embedded/news/fro
  mms/sqlce.asp
• http//www.microsoft.com/sql/productinfo/ceovervie
  w.htm
• http//www.microsoft.com/embedded
• http//www.microsoft.com/SQL/
• Public Newsgroup
• microsoft.public.sqlserver.ce

26
(No Transcript)