Where SQL CE Magic lives...
By 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."
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.
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.
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.
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...