I use RDA and also a little web service call to pull data from a SQL Server 
via either an ethernet cradle or via WiFi.

Now our installs use an ethernet cradle to dock the Symbol 8800s running 
Windows Mobile 2003.  I'm developing in VS2005 and am now using CF2 and 
SQLCE 3.1.

I really need to have the syncing going on in the background while the user 
is using the device to scan etc. in the field....so that the updating is 
seamless in the background and doesn't intefere with the app usage.  Is this 
possible?

Especially with RDA pull where you basically have to delete the table before 
pulling down a new table........

Any advice here - I've been needing a solution to this for years now and 
wondered if technology might've come up with an answer.

TIA
Harry

If you're constantly in contact with the server, never out of range, it 
seems like you could avoid pulling everything down and just use remote data 
access to talk to the server directly from the device for each operation.

Paul T.

"Harry Simpson"  wrote in message 
news:%23UL5KgQ4HHA.5724@TK2MSFTNGP05.phx.gbl...

>I use RDA and also a little web service call to pull data from a SQL Server 
>via either an ethernet cradle or via WiFi.
>
> Now our installs use an ethernet cradle to dock the Symbol 8800s running 
> Windows Mobile 2003.  I'm developing in VS2005 and am now using CF2 and 
> SQLCE 3.1.
>
> I really need to have the syncing going on in the background while the 
> user is using the device to scan etc. in the field....so that the updating 
> is seamless in the background and doesn't intefere with the app usage.  Is 
> this possible?
>
> Especially with RDA pull where you basically have to delete the table 
> before pulling down a new table........
>
> Any advice here - I've been needing a solution to this for years now and 
> wondered if technology might've come up with an answer.
>
> TIA
> Harry
> 

So just communicate via the web service then.....this would scale ok?  like 
40 connections at a time?
I've just never tried to do the wireless deal and don't know how it'd scale 
but I suppose the web service would be about like a web app right?

Harry

"Paul G. Tobey [eMVP]" <p space tobey no spam AT no instrument no spam DOT 
com> wrote in message news:%23F2YpsQ4HHA.2208@TK2MSFTNGP06.phx.gbl...

> If you're constantly in contact with the server, never out of range, it 
> seems like you could avoid pulling everything down and just use remote 
> data access to talk to the server directly from the device for each 
> operation.
>
> Paul T.
>
> "Harry Simpson"  wrote in message 
> news:%23UL5KgQ4HHA.5724@TK2MSFTNGP05.phx.gbl...
>>I use RDA and also a little web service call to pull data from a SQL 
>>Server via either an ethernet cradle or via WiFi.
>>
>> Now our installs use an ethernet cradle to dock the Symbol 8800s running 
>> Windows Mobile 2003.  I'm developing in VS2005 and am now using CF2 and 
>> SQLCE 3.1.
>>
>> I really need to have the syncing going on in the background while the 
>> user is using the device to scan etc. in the field....so that the 
>> updating is seamless in the background and doesn't intefere with the app 
>> usage.  Is this possible?
>>
>> Especially with RDA pull where you basically have to delete the table 
>> before pulling down a new table........
>>
>> Any advice here - I've been needing a solution to this for years now and 
>> wondered if technology might've come up with an answer.
>>
>> TIA
>> Harry
>>
>
> 

I wouldn't imagine much of a problem for 40 connections.  I wasn't actually 
suggesting connecting to the Web service at all, however, but directly to 
SQL Server.  It shouldn't have any problems handling 40 connections...

Paul T.

"Harry Simpson"  wrote in message 
news:egdklPR4HHA.5852@TK2MSFTNGP02.phx.gbl...

> So just communicate via the web service then.....this would scale ok? 
> like 40 connections at a time?
> I've just never tried to do the wireless deal and don't know how it'd 
> scale but I suppose the web service would be about like a web app right?
>
> Harry
>
> "Paul G. Tobey [eMVP]" <p space tobey no spam AT no instrument no spam DOT 
> com> wrote in message news:%23F2YpsQ4HHA.2208@TK2MSFTNGP06.phx.gbl...
>> If you're constantly in contact with the server, never out of range, it 
>> seems like you could avoid pulling everything down and just use remote 
>> data access to talk to the server directly from the device for each 
>> operation.
>>
>> Paul T.
>>
>> "Harry Simpson"  wrote in message 
>> news:%23UL5KgQ4HHA.5724@TK2MSFTNGP05.phx.gbl...
>>>I use RDA and also a little web service call to pull data from a SQL 
>>>Server via either an ethernet cradle or via WiFi.
>>>
>>> Now our installs use an ethernet cradle to dock the Symbol 8800s running 
>>> Windows Mobile 2003.  I'm developing in VS2005 and am now using CF2 and 
>>> SQLCE 3.1.
>>>
>>> I really need to have the syncing going on in the background while the 
>>> user is using the device to scan etc. in the field....so that the 
>>> updating is seamless in the background and doesn't intefere with the app 
>>> usage.  Is this possible?
>>>
>>> Especially with RDA pull where you basically have to delete the table 
>>> before pulling down a new table........
>>>
>>> Any advice here - I've been needing a solution to this for years now and 
>>> wondered if technology might've come up with an answer.
>>>
>>> TIA
>>> Harry
>>>
>>
>>
>
> 

In this architecture there really wouldn't even be a local SDF database at 
all then. Just direct communication with the SQL Server database via wifi 
eh?
Guess you'd want to make transactional updates?  case user interupts the 
save or something?

Thanks
Harry

"Paul G. Tobey [eMVP]" <p space tobey no spam AT no instrument no spam DOT 
com> wrote in message news:O6YNYmR4HHA.2312@TK2MSFTNGP06.phx.gbl...

>I wouldn't imagine much of a problem for 40 connections.  I wasn't actually 
>suggesting connecting to the Web service at all, however, but directly to 
>SQL Server.  It shouldn't have any problems handling 40 connections...
>
> Paul T.
>
> "Harry Simpson"  wrote in message 
> news:egdklPR4HHA.5852@TK2MSFTNGP02.phx.gbl...
>> So just communicate via the web service then.....this would scale ok? 
>> like 40 connections at a time?
>> I've just never tried to do the wireless deal and don't know how it'd 
>> scale but I suppose the web service would be about like a web app right?
>>
>> Harry
>>
>> "Paul G. Tobey [eMVP]" <p space tobey no spam AT no instrument no spam 
>> DOT com> wrote in message news:%23F2YpsQ4HHA.2208@TK2MSFTNGP06.phx.gbl...
>>> If you're constantly in contact with the server, never out of range, it 
>>> seems like you could avoid pulling everything down and just use remote 
>>> data access to talk to the server directly from the device for each 
>>> operation.
>>>
>>> Paul T.
>>>
>>> "Harry Simpson"  wrote in message 
>>> news:%23UL5KgQ4HHA.5724@TK2MSFTNGP05.phx.gbl...
>>>>I use RDA and also a little web service call to pull data from a SQL 
>>>>Server via either an ethernet cradle or via WiFi.
>>>>
>>>> Now our installs use an ethernet cradle to dock the Symbol 8800s 
>>>> running Windows Mobile 2003.  I'm developing in VS2005 and am now using 
>>>> CF2 and SQLCE 3.1.
>>>>
>>>> I really need to have the syncing going on in the background while the 
>>>> user is using the device to scan etc. in the field....so that the 
>>>> updating is seamless in the background and doesn't intefere with the 
>>>> app usage.  Is this possible?
>>>>
>>>> Especially with RDA pull where you basically have to delete the table 
>>>> before pulling down a new table........
>>>>
>>>> Any advice here - I've been needing a solution to this for years now 
>>>> and wondered if technology might've come up with an answer.
>>>>
>>>> TIA
>>>> Harry
>>>>
>>>
>>>
>>
>>
>
> 

Yes, that's what I'm talking about.  If you have multiple updates that must 
all be done or none of them be done, yes, you'd need to transact.  You'd 
probably use transactions anyway, for that matter.  If you got a cancel 
indication from the UI while you were in the middle of some long update, you 
should be able to abort the transaction.

Paul T.

"Harry Simpson"  wrote in message 
news:ObQjVXA5HHA.2312@TK2MSFTNGP06.phx.gbl...

> In this architecture there really wouldn't even be a local SDF database at 
> all then. Just direct communication with the SQL Server database via wifi 
> eh?
> Guess you'd want to make transactional updates?  case user interupts the 
> save or something?
>
> Thanks
> Harry
>
> "Paul G. Tobey [eMVP]" <p space tobey no spam AT no instrument no spam DOT 
> com> wrote in message news:O6YNYmR4HHA.2312@TK2MSFTNGP06.phx.gbl...
>>I wouldn't imagine much of a problem for 40 connections.  I wasn't 
>>actually suggesting connecting to the Web service at all, however, but 
>>directly to SQL Server.  It shouldn't have any problems handling 40 
>>connections...
>>
>> Paul T.
>>
>> "Harry Simpson"  wrote in message 
>> news:egdklPR4HHA.5852@TK2MSFTNGP02.phx.gbl...
>>> So just communicate via the web service then.....this would scale ok? 
>>> like 40 connections at a time?
>>> I've just never tried to do the wireless deal and don't know how it'd 
>>> scale but I suppose the web service would be about like a web app right?
>>>
>>> Harry
>>>
>>> "Paul G. Tobey [eMVP]" <p space tobey no spam AT no instrument no spam 
>>> DOT com> wrote in message 
>>> news:%23F2YpsQ4HHA.2208@TK2MSFTNGP06.phx.gbl...
>>>> If you're constantly in contact with the server, never out of range, it 
>>>> seems like you could avoid pulling everything down and just use remote 
>>>> data access to talk to the server directly from the device for each 
>>>> operation.
>>>>
>>>> Paul T.
>>>>
>>>> "Harry Simpson"  wrote in message 
>>>> news:%23UL5KgQ4HHA.5724@TK2MSFTNGP05.phx.gbl...
>>>>>I use RDA and also a little web service call to pull data from a SQL 
>>>>>Server via either an ethernet cradle or via WiFi.
>>>>>
>>>>> Now our installs use an ethernet cradle to dock the Symbol 8800s 
>>>>> running Windows Mobile 2003.  I'm developing in VS2005 and am now 
>>>>> using CF2 and SQLCE 3.1.
>>>>>
>>>>> I really need to have the syncing going on in the background while the 
>>>>> user is using the device to scan etc. in the field....so that the 
>>>>> updating is seamless in the background and doesn't intefere with the 
>>>>> app usage.  Is this possible?
>>>>>
>>>>> Especially with RDA pull where you basically have to delete the table 
>>>>> before pulling down a new table........
>>>>>
>>>>> Any advice here - I've been needing a solution to this for years now 
>>>>> and wondered if technology might've come up with an answer.
>>>>>
>>>>> TIA
>>>>> Harry
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>