473,376 Members | 1,019 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,376 software developers and data experts.

Synchronising SQL Server 2005 mobile with SQL Server 2005 Express

Hi
I have an application which runs on a desktop.
I want to synchronise the DB with a PDA app, which also uses SQL Server 2005
(mobile and express).

I believe that I will need to write my own synchronization application, in
order to update the data across the machines.
My questions are:
- Is there a way of picking up an event that will notify my application when
the PDA is connected to the desktop??
- How can I connect to the PDA DB from the Desktop application?? (ie. do I
just use a connection string from the Desktop machine, but which connects to
the PDA DB??)
- Once I have this connected, I presume I will be able to compare the
data on the desktop machine, against the data on the PDA, and update each
accordingly?

Any examples of this being done, or details of best practices for this would
be much appreciated

Thanks
Nov 30 '05 #1
7 2168
Paul,

Before writing a single line of code, I'd look at the products here:

www.primeworks.pt

I don't know if he has support for SQL Mobile yet, but this would be the
very easiest approach and for a very reasonable price.

--
Ginny Caughey
..NET Compact Framework MVP
"Paul Aspinall" <pa**@aspy.co.uk> wrote in message
news:YD******************@fe1.news.blueyonder.co.u k...
Hi
I have an application which runs on a desktop.
I want to synchronise the DB with a PDA app, which also uses SQL Server
2005 (mobile and express).

I believe that I will need to write my own synchronization application, in
order to update the data across the machines.
My questions are:
- Is there a way of picking up an event that will notify my application
when the PDA is connected to the desktop??
- How can I connect to the PDA DB from the Desktop application?? (ie. do I
just use a connection string from the Desktop machine, but which connects
to the PDA DB??)
- Once I have this connected, I presume I will be able to compare the
data on the desktop machine, against the data on the PDA, and update each
accordingly?

Any examples of this being done, or details of best practices for this
would be much appreciated

Thanks

Nov 30 '05 #2
As far as I understand you intend to put the locus control on the desktop
machine.
In other words you will have a running application on the desktop machine,
which should "sense" a connected PDA and eventually start a sync process,
right?
If this is not a kind of a requirement and there are not other forces, which
I do not know, you may evaluate other approaches as well, which may be more
beneficial in terms of development effort and even scalability.
What I am talking about is transferring locus control into the PDA- e.g.
writing PDA application which should "sense" connection and initiate the
sync process.
Some of the synchronization approaches you may use are: RDA, Merge
replication and even Xml Web Services if the 2 previous methods does not fit
your requirements...

--
Ruslan Trifonov
blog: http://xman892.blogspot.com
"Paul Aspinall" <pa**@aspy.co.uk> wrote in message
news:YD******************@fe1.news.blueyonder.co.u k...
Hi
I have an application which runs on a desktop.
I want to synchronise the DB with a PDA app, which also uses SQL Server
2005 (mobile and express).

I believe that I will need to write my own synchronization application, in
order to update the data across the machines.
My questions are:
- Is there a way of picking up an event that will notify my application
when the PDA is connected to the desktop??
- How can I connect to the PDA DB from the Desktop application?? (ie. do I
just use a connection string from the Desktop machine, but which connects
to the PDA DB??)
- Once I have this connected, I presume I will be able to compare the
data on the desktop machine, against the data on the PDA, and update each
accordingly?

Any examples of this being done, or details of best practices for this
would be much appreciated

Thanks

Nov 30 '05 #3
you cannot use RDA or merge replication between SQL Mobile and
SQL Express.
--
Darren Shaffer
..NET Compact Framework MVP
Principal Architect
Connected Innovation
www.connectedinnovation.com

"Ruslan Trifonov" <ru*************@ritsoftware.com> wrote in message
news:eu*************@TK2MSFTNGP15.phx.gbl...
As far as I understand you intend to put the locus control on the desktop
machine.
In other words you will have a running application on the desktop machine,
which should "sense" a connected PDA and eventually start a sync process,
right?
If this is not a kind of a requirement and there are not other forces,
which I do not know, you may evaluate other approaches as well, which may
be more beneficial in terms of development effort and even scalability.
What I am talking about is transferring locus control into the PDA- e.g.
writing PDA application which should "sense" connection and initiate the
sync process.
Some of the synchronization approaches you may use are: RDA, Merge
replication and even Xml Web Services if the 2 previous methods does not
fit your requirements...

--
Ruslan Trifonov
blog: http://xman892.blogspot.com
"Paul Aspinall" <pa**@aspy.co.uk> wrote in message
news:YD******************@fe1.news.blueyonder.co.u k...
Hi
I have an application which runs on a desktop.
I want to synchronise the DB with a PDA app, which also uses SQL Server
2005 (mobile and express).

I believe that I will need to write my own synchronization application,
in order to update the data across the machines.
My questions are:
- Is there a way of picking up an event that will notify my application
when the PDA is connected to the desktop??
- How can I connect to the PDA DB from the Desktop application?? (ie. do
I just use a connection string from the Desktop machine, but which
connects to the PDA DB??)
- Once I have this connected, I presume I will be able to compare the
data on the desktop machine, against the data on the PDA, and update each
accordingly?

Any examples of this being done, or details of best practices for this
would be much appreciated

Thanks


Dec 1 '05 #4
In my opinion it should be the PDA initiating the sync and making a request
to the machine to get its data, not the other way around.

"Paul Aspinall" <pa**@aspy.co.uk> wrote in message
news:YD******************@fe1.news.blueyonder.co.u k...
Hi
I have an application which runs on a desktop.
I want to synchronise the DB with a PDA app, which also uses SQL Server
2005 (mobile and express).

I believe that I will need to write my own synchronization application, in
order to update the data across the machines.
My questions are:
- Is there a way of picking up an event that will notify my application
when the PDA is connected to the desktop??
- How can I connect to the PDA DB from the Desktop application?? (ie. do I
just use a connection string from the Desktop machine, but which connects
to the PDA DB??)
- Once I have this connected, I presume I will be able to compare the
data on the desktop machine, against the data on the PDA, and update each
accordingly?

Any examples of this being done, or details of best practices for this
would be much appreciated

Thanks

Dec 1 '05 #5
Thanks to all that replied.

It looks like RDA, Merge Replication and Web services are all out (I don't
want to use IIS).

Does anyone know of an example of how to do this??
All pointers to articles / code samples / discussions welcomed.

Thanks
"Darren Shaffer" <da***********@discussions.microsoft.com> wrote in message
news:e7*************@TK2MSFTNGP15.phx.gbl...
you cannot use RDA or merge replication between SQL Mobile and
SQL Express.
--
Darren Shaffer
.NET Compact Framework MVP
Principal Architect
Connected Innovation
www.connectedinnovation.com

"Ruslan Trifonov" <ru*************@ritsoftware.com> wrote in message
news:eu*************@TK2MSFTNGP15.phx.gbl...
As far as I understand you intend to put the locus control on the desktop
machine.
In other words you will have a running application on the desktop
machine, which should "sense" a connected PDA and eventually start a sync
process, right?
If this is not a kind of a requirement and there are not other forces,
which I do not know, you may evaluate other approaches as well, which may
be more beneficial in terms of development effort and even scalability.
What I am talking about is transferring locus control into the PDA- e.g.
writing PDA application which should "sense" connection and initiate the
sync process.
Some of the synchronization approaches you may use are: RDA, Merge
replication and even Xml Web Services if the 2 previous methods does not
fit your requirements...

--
Ruslan Trifonov
blog: http://xman892.blogspot.com
"Paul Aspinall" <pa**@aspy.co.uk> wrote in message
news:YD******************@fe1.news.blueyonder.co.u k...
Hi
I have an application which runs on a desktop.
I want to synchronise the DB with a PDA app, which also uses SQL Server
2005 (mobile and express).

I believe that I will need to write my own synchronization application,
in order to update the data across the machines.
My questions are:
- Is there a way of picking up an event that will notify my application
when the PDA is connected to the desktop??
- How can I connect to the PDA DB from the Desktop application?? (ie. do
I just use a connection string from the Desktop machine, but which
connects to the PDA DB??)
- Once I have this connected, I presume I will be able to compare the
data on the desktop machine, against the data on the PDA, and update
each accordingly?

Any examples of this being done, or details of best practices for this
would be much appreciated

Thanks



Dec 1 '05 #6
Paul - with all due respect, you're effectively taking everything off the
table. Technically speaking, you don't *need* IIS to create or consume a
web service right?

I think the only two avenues left are transferring data through sockets or
writing to some file and moving it around. But that's such a pain in the
butt and there are a ton of issues here as well. Replication is tried and
tested over and over and is probably the most reliable way your going to
come across. Next is web services but you're going to have to roll your own
checks all over the place if you do this. I've done it and it's a real
pain. Not impossible, not even hard in real terms, but monotonous, boring
and painful.

Ok but to answer your question I need to know one more thing - are you
using ActiveSync ? Is that a possibility
"Paul Aspinall" <pa**@aspy.co.uk> wrote in message
news:pH********************@fe3.news.blueyonder.co .uk...
Thanks to all that replied.

It looks like RDA, Merge Replication and Web services are all out (I don't
want to use IIS).

Does anyone know of an example of how to do this??
All pointers to articles / code samples / discussions welcomed.

Thanks
"Darren Shaffer" <da***********@discussions.microsoft.com> wrote in
message news:e7*************@TK2MSFTNGP15.phx.gbl...
you cannot use RDA or merge replication between SQL Mobile and
SQL Express.
--
Darren Shaffer
.NET Compact Framework MVP
Principal Architect
Connected Innovation
www.connectedinnovation.com

"Ruslan Trifonov" <ru*************@ritsoftware.com> wrote in message
news:eu*************@TK2MSFTNGP15.phx.gbl...
As far as I understand you intend to put the locus control on the
desktop machine.
In other words you will have a running application on the desktop
machine, which should "sense" a connected PDA and eventually start a
sync process, right?
If this is not a kind of a requirement and there are not other forces,
which I do not know, you may evaluate other approaches as well, which
may be more beneficial in terms of development effort and even
scalability.
What I am talking about is transferring locus control into the PDA- e.g.
writing PDA application which should "sense" connection and initiate the
sync process.
Some of the synchronization approaches you may use are: RDA, Merge
replication and even Xml Web Services if the 2 previous methods does not
fit your requirements...

--
Ruslan Trifonov
blog: http://xman892.blogspot.com
"Paul Aspinall" <pa**@aspy.co.uk> wrote in message
news:YD******************@fe1.news.blueyonder.co.u k...
Hi
I have an application which runs on a desktop.
I want to synchronise the DB with a PDA app, which also uses SQL Server
2005 (mobile and express).

I believe that I will need to write my own synchronization application,
in order to update the data across the machines.
My questions are:
- Is there a way of picking up an event that will notify my application
when the PDA is connected to the desktop??
- How can I connect to the PDA DB from the Desktop application?? (ie.
do I just use a connection string from the Desktop machine, but which
connects to the PDA DB??)
- Once I have this connected, I presume I will be able to compare
the data on the desktop machine, against the data on the PDA, and
update each accordingly?

Any examples of this being done, or details of best practices for this
would be much appreciated

Thanks



Dec 2 '05 #7
I'm trying to achieve something like Pocket Money...

It basically has a DB on the Desktop, and syncs with the PDA.
I want to write an app which has similar functionality. This should be
possible, I just need to know how...

IIS and SQL replication are not required in this scenario.

ActiveSync is a possibility, but... how?

Thanks
"W.G. Ryan - MVP" <Wi*********@nospam.gmail.com> wrote in message
news:OO**************@TK2MSFTNGP10.phx.gbl...
Paul - with all due respect, you're effectively taking everything off the
table. Technically speaking, you don't *need* IIS to create or consume a
web service right?

I think the only two avenues left are transferring data through sockets or
writing to some file and moving it around. But that's such a pain in the
butt and there are a ton of issues here as well. Replication is tried and
tested over and over and is probably the most reliable way your going to
come across. Next is web services but you're going to have to roll your
own checks all over the place if you do this. I've done it and it's a
real pain. Not impossible, not even hard in real terms, but monotonous,
boring and painful.

Ok but to answer your question I need to know one more thing - are you
using ActiveSync ? Is that a possibility
"Paul Aspinall" <pa**@aspy.co.uk> wrote in message
news:pH********************@fe3.news.blueyonder.co .uk...
Thanks to all that replied.

It looks like RDA, Merge Replication and Web services are all out (I
don't want to use IIS).

Does anyone know of an example of how to do this??
All pointers to articles / code samples / discussions welcomed.

Thanks
"Darren Shaffer" <da***********@discussions.microsoft.com> wrote in
message news:e7*************@TK2MSFTNGP15.phx.gbl...
you cannot use RDA or merge replication between SQL Mobile and
SQL Express.
--
Darren Shaffer
.NET Compact Framework MVP
Principal Architect
Connected Innovation
www.connectedinnovation.com

"Ruslan Trifonov" <ru*************@ritsoftware.com> wrote in message
news:eu*************@TK2MSFTNGP15.phx.gbl...
As far as I understand you intend to put the locus control on the
desktop machine.
In other words you will have a running application on the desktop
machine, which should "sense" a connected PDA and eventually start a
sync process, right?
If this is not a kind of a requirement and there are not other forces,
which I do not know, you may evaluate other approaches as well, which
may be more beneficial in terms of development effort and even
scalability.
What I am talking about is transferring locus control into the PDA-
e.g. writing PDA application which should "sense" connection and
initiate the sync process.
Some of the synchronization approaches you may use are: RDA, Merge
replication and even Xml Web Services if the 2 previous methods does
not fit your requirements...

--
Ruslan Trifonov
blog: http://xman892.blogspot.com
"Paul Aspinall" <pa**@aspy.co.uk> wrote in message
news:YD******************@fe1.news.blueyonder.co.u k...
> Hi
> I have an application which runs on a desktop.
> I want to synchronise the DB with a PDA app, which also uses SQL
> Server 2005 (mobile and express).
>
> I believe that I will need to write my own synchronization
> application, in order to update the data across the machines.
> My questions are:
> - Is there a way of picking up an event that will notify my
> application when the PDA is connected to the desktop??
> - How can I connect to the PDA DB from the Desktop application?? (ie.
> do I just use a connection string from the Desktop machine, but which
> connects to the PDA DB??)
> - Once I have this connected, I presume I will be able to compare
> the data on the desktop machine, against the data on the PDA, and
> update each accordingly?
>
> Any examples of this being done, or details of best practices for this
> would be much appreciated
>
> Thanks
>



Dec 3 '05 #8

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: NetIdiot | last post by:
I have had to install and uninstall VS.NET 2005 a couple of times because of some errors. The SQL Server express refuses to install ... and hence I can't most things I want to work on. I even tried...
0
by: Zorba.GR | last post by:
IBM DB2 Connect Enterprise Edition v8.2, other IBM DB2 (32 bit, 64 bit) (MULTiOS, Windows, Linux, Solaris), IBM iSoft Commerce Suite Server Enterprise v3.2.01, IBM Tivoli Storage Resource Manager...
0
by: Paul Aspinall | last post by:
Hi I have an application which runs on a desktop. I want to synchronise the DB with a PDA app, which also uses SQL Server 2005 (mobile and express). I believe that I will need to write my own...
2
by: Paul Aspinall | last post by:
Hi I have an application which runs on a desktop. I want to synchronise the DB with a PDA app, which also uses SQL Server 2005 (mobile and express). How can I connect to the Desktop DB, from...
1
by: John | last post by:
Hi We have an internal ms access database which we need to synchronise with our website with sql server 2005 backend which is hosted on a public host. My question is; is there a way to keep the...
1
by: Peter | last post by:
I've purchased VS.NET 2005 Standard and have tried to install SQL Server 2005 Express, but get the following error in the error log. Please could someone help me.... Microsoft SQL Server 2005...
1
by: Dan Bass | last post by:
-- Installed -- Visual Studio 2005 (.Net 2.0) Sql Server 2005 Express Sql Server 2005 Mobile SDK I'm trying to add a "SQL Mobile Database" component to my Smart Device project through Visual...
4
by: Wolfgang Kraus | last post by:
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...
2
by: jhf | last post by:
Hi, I have developed some VB software that enables a pocket pc under Windows Mobile 2003 OS to communicate with an MS SQL Server 2005 Express database on a PC under XP, using...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.