Hi,

i want to create a solution which shall consist of a sql server 2005 -
data base (express edition if the following features are available by
express edition) and a mobile windows application (running on a
smartphone under windows mobile 5.0).

The sql server shall be installed on a ordinary laptop using windows
xp (not professionall edition).

Which would be the best way to exchange the data between mobile device
and pc? I learned that there is a SQL Server Compact Edition for the
mobile device and that rda would be a way to exchange data - but then
i would need internet information system and this does not run on xp
home edition.

Which alternatives would you suggest me?

Thanx in advance

Wolfgang

Hi,

I noticed nobody responding to my posting. Might this be the wrong
place for this topic?

Kind regards

Wolfgang

I know very little about SQL Server CE and RDA but it seems the alternative
out-of-the-box solution is merge replication. However, SQL Express can only
be a subscriber so you would then need then need SQL Server Workgroup
Edition instead, which doesn't run on XP Home Edition either. If Windows XP
Pro (or Windows Vista Business/Ultimate) is not an option, I think you'll
need to develop your own merge/sync solution.


--
Hope this helps.

Dan Guzman
SQL Server MVP

"Wolfgang Kraus" <wokas2005 (AT) freenet (DOT) de> wrote

A more appropriate group for SQL Server CE questions is
microsoft.public.sqlserver.ce.


--
Hope this helps.

Dan Guzman
SQL Server MVP

"Wolfgang Kraus" <wokas2005 (AT) freenet (DOT) de> wrote

The two main methods for synchronizing data between SQL Server Compact
Edition and other editions are RDA and merge replication. However, I believe
both require IIS in order to work.

Two alternatives:

- Using the ADO.NET Sync Framework (still in CTP). Here are a few links with
info on that:
http://oakleafblog.blogspot.com/2006...asionally.html
http://blogs.msdn.com/stevelasker/ar...available.aspx
http://www.microsoft.com/downloads/d...displaylang=en

- Develop your own synchronization process. Depending on your requirements
it could be an easy or difficult task. For example, I had a system where
mobile users could change data in only two tables (plus data had some level
of segmentation between users). It was a pretty straight forward process to
compare and synchronize data.

You may get more help and ideas posting in microsoft.public.sqlserver.ce.

HTH,

Plamen Ratchev
http://www.SQLStudio.com