Mobile Solution with SQL Server 2005 Express edition and smartphone

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

Re: Mobile Solution with SQL Server 2005 Express edition and smartphone

Hi,

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

Kind regards

Wolfgang

Re: Mobile Solution with SQL Server 2005 Express edition and smartphone

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" wrote in message
news:1178290163.787334.141120@l77g2000hsb.googlegroups.com.. .
> 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
>

Re: Mobile Solution with SQL Server 2005 Express edition and smartphone

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


--
Hope this helps.

Dan Guzman
SQL Server MVP

"Wolfgang Kraus" wrote in message
news:1178523278.208787.108430@q75g2000hsh.googlegroups.com.. .
> Hi,
>
> I noticed nobody responding to my posting. Might this be the wrong
> place for this topic?
>
> Kind regards
>
> Wolfgang
>

Re: Mobile Solution with SQL Server 2005 Express edition and smartphone

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/11/adonet-sync-framewor k-for-occasionally.html
http://blogs.msdn.com/stevelasker/archive/2007/01/23/sync-se rvices-for-ado-net-ocs-ctp-now-available.aspx
http://www.microsoft.com/downloads/details.aspx?familyid=75F EF59F-1B5E-49BC-A21A-9EF4F34DE6FC&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