|
Home Page | Development | SQL Server for CE
An overview of SQL Replication options
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." 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.
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.
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.
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... SQL Server for CE 2000 and RDA with eVB.
This application collects data in a SQL Server 2000 CE database on the PocketPC. When connectivity becomes available, the eVB application pushes new records from the local SQL database to the server. SQL Server for CE Achitecture and Replication using eVB.
If you are planning a Pocket PC based mobile application using SQL Server for CE you need to understand the replication options and mechanisms. Installing SQL Server 2000 Windows CE Edition.
This article guides you through the steps of installing SQL Server 2000 for Windows CE.
|