Skip to Main Content
Programming SQL Server 2005
book

Programming SQL Server 2005

by Bill Hamilton
February 2006
Intermediate to advanced content levelIntermediate to advanced
586 pages
17h 35m
English
O'Reilly Media, Inc.
Content preview from Programming SQL Server 2005

Chapter 21. SQL Server Mobile Edition

Microsoft SQL Server Mobile Edition (SQL Server Mobile) is the update to Microsoft SQL Server 2000 Windows CE Edition 2.0 (SQL Server CE). It extends enterprise solutions to applications running on a device by delivering relational database functionality in a compact footprint and by providing a consistent programming model. SQL Server Mobile is typically used on devices that run Windows CE 5.0, Windows XP Tablet PC Edition, Mobile Pocket PC, or Mobile Smartphone. You can also run SQL Server Mobile on a desktop Windows operating system for development and testing purposes.

SQL Server Mobile is integrated with the .NET Compact Framework—a subset of the .NET Framework that provides a hardware-independent environment for running applications on resource-constrained computing devices. SQL Server Mobile can be deployed as part of a Microsoft .NET Compact Framework application or independently on a smart device. The .NET Compact Framework Data Provider for SQL Server Mobile in the namespace System.Data.SqlServerCe provides access to data from .NET Compact Framework applications.

Remote data access and merge replication deliver data from SQL Server to SQL Server Mobile on supported devices. This data can be manipulated offline and later synchronized to the server when a connection is available.

A SQL Server Mobile database is stored in a file with a .sdf extension. A SQL Server Mobile database can be up to 4GB in size. Devices running SQL Server Mobile ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Programming Microsoft® SQL Server® 2012

Programming Microsoft® SQL Server® 2012

Leonard Lobel and Andrew Brust

Publisher Resources

ISBN: 0596004796Supplemental ContentErrata Page