0-672-32922-0Sams 9780672329227 0672329220Jul-07 List Price: $59.99Paperback601 pages Our Price: $47.99 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 Prashant Dhingra is currently a Lead Program Manager at Microsoft. From 2004 to 2005 he was Product Manager for SQL Server Mobile Edition. Prior to that, Prashant architected one of the world’s largest mobile device implementations. He has written articles for MSDN and presented at conferences on mobile devices and database technologies. Trent Swanson is a Program Manager at Microsoft, working with partners and customers to design, develop, and deploy solutions on the Windows Mobile Platform. He has gained experience and in-depth knowledge into the SQL Server Compact Edition product helping customers and partners migrate and design managed, as well native, mobile applications leveraging SQL Server Compact Edition.