Monday, January 15, 2007

New SQL Server CE Technical Articles and Tutorials

Microsoft released in the last week five tutorials that cover the most important developer features of SQL Server 2005 Compact Edition (SSCE). For a welcome change, tutorials with code come in VB and C# versions. The following sections provide links to both versions, where applicable, and a copy of Microsoft's summary for each.


Application Deployment with Shared and Private Deployments (VB) Application Deployment with Shared and Private Deployments (C#) Summary: In this tutorial, you will learn about two different deployment scenarios available for deploying SQL Server 2005 Compact Edition with your applications: centrally installing SQL Server 2005 Compact Edition and privately installing SQL Server 2005 Compact Edition as part of your application. You will be using Visual Basic.NET in this tutorial. (22 printed pages)
Rapid Application Development Using SQL Server 2005 Compact Edition and Visual Basic.NET Rapid Application Development Using SQL Server 2005 Compact Edition and Visual C#.NET Summary: In this tutorial, you will learn how to leverage the design capabilities integrated into Visual Studio 2005 in order to rapidly develop applications that use data stored in a SQL Server 2005 Compact Edition database. You will be using Visual Basic.NET in this tutorial. (21 printed pages)
SQL Server 2005 Compact Edition Data Access with the SqlCeResultSet and Visual Basic.NET SQL Server 2005 Compact Edition Data Access with the SqlCeResultSet and Visual C#.NET Summary: In this tutorial, you will learn how to leverage the design capabilities integrated into Visual Studio 2005 in order to rapidly develop applications that use data stored in a SQL Server 2005 Compact Edition database. You will be using Visual Basic.NET in this tutorial. (21 printed pages)
Configuring Internet Information Services for SQL Server 2005 Compact Edition Remote Data Access and Merge Replication Summary: Learn how to configure Internet Information Services (IIS) for both remote data access (RDA) and merge replication, two technologies that you can use to synchronize data between a Microsoft SQL Server 2005 back-end database and a local Microsoft SQL Server 2005 Compact Edition database. This tutorial covers everything that you must do to configure a server for data synchronization using RDA. To perform data synchronization with merge replication, you must also configure SQL Server 2005. Remote Data Access Synchronization with SQL Server 2005 Compact Edition and Visual Basic.NET
Remote Data Access Synchronization with SQL Server 2005 Compact Edition and Visual Basic.NET Remote Data Access Synchronization with SQL Server 2005 Compact Edition and Visual C#.NET Summary: In this tutorial, you will learn how to create a Microsoft Windows Forms application using Microsoft Visual Basic.NET that synchronizes data between a Microsoft SQL Server 2005 database and a Microsoft SQL Server 2005 Compact Edition database using Microsoft SQL Server 2005 Compact Edition Remote Data Access (RDA). (48 printed pages)
The tutorials claim that Windows XP SP2, Visual Studio 2005 SP1 (not Visual Studio Express), and SSCE components are required to run the tutorials. I plan to test them with Windows Vista Ultimate, VS 2005 SP1 with Visual Studio 2005 Service Pack 1 Update for Windows Vista Beta, SQL Server 2005 Standard Edition SP2 December CTP for replication. Stay tuned for my results. Update 1/17/2007: There's a new "What's New in SQL Server Compact Edition" whitepaper and updated "An introduction to SQL Server 2005 Compact Edition" Knowledge Base article available. Technorati tags:
, , , , , , , , , , , ,