By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,564 Members | 1,070 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,564 IT Pros & Developers. It's quick & easy.

Mobile Solution with SQL Server 2005 Express edition and smartphone

P: n/a
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

May 4 '07 #1
Share this Question
Share on Google+
4 Replies


P: n/a
Hi,

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

Kind regards

Wolfgang

May 7 '07 #2

P: n/a
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" <wo*******@freenet.dewrote in message
news:11**********************@l77g2000hsb.googlegr oups.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
May 7 '07 #3

P: n/a
A more appropriate group for SQL Server CE questions is
microsoft.public.sqlserver.ce.
--
Hope this helps.

Dan Guzman
SQL Server MVP

"Wolfgang Kraus" <wo*******@freenet.dewrote in message
news:11**********************@q75g2000hsh.googlegr oups.com...
Hi,

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

Kind regards

Wolfgang
May 7 '07 #4

P: n/a
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
May 7 '07 #5

This discussion thread is closed

Replies have been disabled for this discussion.