Mobile Solution with SQL Server 2005 Express edition and smartphone

Wolfgang Kraus

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

Subscribe Reply

4099

Wolfgang Kraus

Hi,

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

Kind regards

Wolfgang

May 7 '07 #2

Dan Guzman

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*******@free net.dewrote in message
news:11******** **************@ l77g2000hsb.goo glegroups.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

Dan Guzman

A more appropriate group for SQL Server CE questions is
microsoft.publi c.sqlserver.ce.
--
Hope this helps.

Dan Guzman
SQL Server MVP

"Wolfgang Kraus" <wo*******@free net.dewrote in message
news:11******** **************@ q75g2000hsh.goo glegroups.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

Plamen Ratchev

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.publi c.sqlserver.ce.

HTH,

Plamen Ratchev
http://www.SQLStudio.com

May 7 '07 #5

Similar topics

1118

Visual C# Express 2005 Beta 2

by: Harry | last post by:

Is it possible to write Smartphone applications using Visual C# Express 2005 Beta 2... It is not listed on the Installed templates.. Could you please let me have the download address to be able to create a Smartphone Application. Thanks Guys

C# / C Sharp

1564

Mobile Device developmnet

by: vul | last post by:

I've got a request from my boss to give some users the ability to connect to SQL Server database while they are on the road. I'm VB6 and VB.Net (beginner) developer. Mobile devices were not bought yet. So it depends on my research what to buy. I decided to start a simple application in VB 2005. There are 3 options for Smart Device applications: Pocket PC 2003, Smartphone PC 2003, Windows CE 5.0

.NET Framework

1473

Visual Studio and SQL Server - basic question

by: JJ | last post by:

My potential shared hosting platform uses SQL server 2005. I am developing on the Express version. In order to make sure I am not going to cause myself any problems when I move my ASP .net 2.0 sites (developed in Vis Studio 2005) to the host, should I be using my developers version of SQL 2005? If so, can I install it and keep my current instance of the SQL Server Express edition? Or will installing the dev version upgrade that...

ASP.NET

1670

SQL Server 2005 + SQL Server Express

by: farseer | last post by:

Hi, I have SQL Server 2005 installed on my dev system. I am working on an app that i would like to distribute SQL Server with. SQL Server EXpress edition seem to be ideal for this. My questions are: -If i installed Express Edition, Can both SQL Server 2005 and Express Edition coincide peacefully on the same PC? -Which one will Visual Studio see? (currently i created by database using VS, which i assumed created a SQL Server 2005...

Microsoft SQL Server

3039

Is SQL server not installed with VS2005

by: Developer | last post by:

Hello All, i have recently installed VS2005 and was trying to install SQL sever 2000. I have Win XP' SP2. But when I tried installing, it only installed client tools and not the database. Can anyone please help me with this as I want to install SQL server and also wouold be grateful, if you can suggest me any workaround to dealwith this problem.(Like should I install any new OS etc). Any help would be appreciated.

ASP.NET

2097

MS SQL Server 2005 Express Edition

by: kress1963nov22 | last post by:

I recently purchased a good MS book ("Build a Web Site Now") by Jim Buyens. It has the Express Edition of MS-Visual Web Developer 2005 on CD and also MS SQL Server 2005 Express Edition on the CD. A couple of questions for this newbie: Can MS SQL Server 2005 Express Edition be used in place of the older MSDE product for backend database work? I also have Visual Studio .NET (VB) 2003 (Standard Edition). How compatible are all these products...

Visual Basic .NET

6442

Sql server express SP2 Bootstrapper package

by: Steve | last post by:

Hi All I downloaded Sql server 2005 express SP2 and attempted to modify the Bootstrapper package files as I did with SP1 When i try to install SQL server as part of my VS 2005 deployment app I get an error at the end of the SQL server install phase 'Invalid endpoint'. (Note SQL server express gets installed OK) If I run SQL server express SP2 setup directly it I don't get the error

Visual Basic .NET

2478

C# Express Edition and mobile projects

by: Pratheep | last post by:

Hi, Can I compile code for mobile devices (Window Mobile 2005) using C# Express or do I need the full version of C# for mobile devices? thanks, Pratheep

C# / C Sharp

4962

C# Web Site. Connecting to SQL Server. Test Connection Fine...BUT

by: samadams_2006 | last post by:

Hello, I have a problem that I'm hoping someone will be able to help me resolve. 1) I have a C# Web Site in which I connect to the database: "Install Microsoft SQL Server 2005 Express Edition" via the link on: http://msdn2.microsoft.com/en-us/express/bb410792.aspx

ASP.NET

8968

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

9334

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

9259

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

8208

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

6750

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

4824

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

3279

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

2744

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

2193

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General