Skip to main content

News

New site design will be posted by Wednesday.
6/2/2008 8:07:00 AM

Windows Mobile Developer Controls
Sapphire Soltuions
Skip Navigation Links Breadcrumb Articles BreadcrumbSQL CE

Articles - SQL Server Compact Edition

Where SQL CE Magic lives...

An overview of SQL Replication options

An overview of SQL Replication optionsBy Jarick Rager and John Burdett of CTS; "SQL Server allows a myriad of options to establish replication and each is discussed in the SQL Server CE Books Online. The problem is determining where to find information suitable for a particular situation. This article describes some of the searches we made and some of the successes we found in building a replication architecture for a common business problem."

Using the SQL Server CE RDA Pull method.

Using the SQL Server CE RDA Pull method.They say the road to hell is paved with good intentions. If so I must have traveled some distance down that path since I have been meaning to add this tutorial for some time! This quick tutorial will show you how to use Remote Data Access (RDA) to pull a table from a SQL Server database, how to connect to the local copy of SQL Server and retrieve the Customer list.

How I used SQL Server CE in my eVB application.

How I used SQL Server CE in my eVB application.In this article, Steven Heyvaert shares some of the SQL Server CE knowledge he has gained implementing SQL Server CE into his eVB application. In addition to the code snippets covering a variety of routine CE database access scenarios, there is also code to fill a grid with a CE recordset.

Use eVB and ADOXCE to build an Enterprise Manager for MS SQL Server for CE.

Use eVB and ADOXCE to build an Enterprise Manager for MS SQL Server for CE.For anyone familiar with using SQL Server on the Desktop, and now looking to use SSCE, one tool that will be missed right away is Enterprise Manager. Tim Chaffee of Object Design Works has written this excellent and pioneering article covering some of the aspects of managing a database on the CE device and the tools that are available to make the job of managing database easier using eVB.

SQL Server CE RDA replication configuration.

SQL Server CE RDA replication configuration.Configuring SQL Server for CE (SS CE) and IIS is critical - and somewhat tedious. Here are some shortcuts and hopefully concise enough of a explanation to get it done in 10 minutes...