Microsoft® sql server 2005, compact edition

  • Authors:
  • Prashant Dhingra;Trent Swanson

  • Affiliations:
  • -;-

  • Venue:
  • Microsoft® sql server 2005, compact edition
  • Year:
  • 2007

Quantified Score

Hi-index 0.02

Visualization

Abstract

SQL Server Compact Edition is a slimmed down version of SQL Server that you can use on Pocket PCs, Smart phones, Tablet PCs, and Desktops. With this book, you will learn how to build applications for resource constrained devices. You'll discover how the SQL Server Compact Edition database can also be used as an embedded in-proc database for desktop-based applications. You'll learn how to manage the SQL Server Compact Edition database using SQL Server Management Studio, Visual Studio, and Query Analyzer.Laptops, Tablet PCs, and mobile devices enable information workers to access enterprise data from remote locations. With the step-by-step exercises provided in this book, you'll learn how to synchronize data between SQL Server and SQL Server Compact Edition. You'll also learn Remote Data Accessï戮聳a lightweight method to exchange data between SQL Server and SQL Server Compact Edition. Also in this book are code samples to help you write database applications for mobile devices and for desktop PCs. Throughout the book you'll find expert tips for building and deploying enterprise applications.Understand how to... Build mobile and desktop applications using SQL Server Compact Edition Set up the development and production environment with Visual Studio, SQL Server, and SQL Server Compact Edition Optimize performance and plan for security Manage databases using SQL Server Management Studio, Visual Studio, and Query Analyzer Develop applications using ADO.NET and OLEDB provider for SQL Server Compact Edition Upgrade from earlier versions of SQL CE, .NET Compact Framework, and Visual Studio Use Merge Replication to synchronize data between SQL Server and SQL Server Compact Edition Exchange data between SQL Server and SQL Server Compact Edition using Remote Data Access Introductionï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 1 1ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 Getting Started with SQL Server 2005 Compact Editionï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 7 2ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 Platform Support and Installation35 3ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 Getting to Know the Toolsï戮 63 4ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 Managing the SQL Server 2005 Compact Edition Databaseï戮 ï戮 ï戮 ï戮 109 5ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 Defining Database Structureï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 131 6ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 Manipulating the Databaseï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 175 7ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 Programming SQL Server 2005 Compact Edition with ADO.NETï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 205 8ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 Introducing Native Access 247 9ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 Using Operators in SQL Server 2005 Compact Editionï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 279 10ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 Using the Built-In Functionsï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 295 11ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 Upgrading from a Previous Versionï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 327 12ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 Synchronizing Data with Merge Replicationï戮 ï戮 345 13ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 Synchronizing Data with Remote Data Accessï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 411 14ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 Securing the SQL Server 2005 Compact Edition Databaseï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 459 15ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 SQL Server 2005 Compact Edition Performance Tuningï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 ï戮 505Indexï戮 ï戮 ï戮 ï戮 ï戮 551