Send data through ActiveSync

[Mystic Mong]

Hi everyone,

Can someone point me in the right direction towards doing the following?
It's not something I've tried to do before so I am not entirely sure what
the best method would be:

I have an app that runs on PPC2003, written in VB.Net (running on Symbol
8846 units). Data is collected in a local SqlCe database and in normal
circumstances is sent via a wireless network to a main Sql Server 2000
database.

However, in some circumstances we need to be able to work in remote sites
(no wireless network, no main server, no network/internet connectivity),
collect the data as usual but then transfer the data collected to an Access
database on a laptop (allow I may end up changing the data source on the
laptop to MSDE). Now, at the moment I get the units to create a local file
containing the data then cradle the unit and sync it with the laptop using
ActiveSync. Then we use File Explorer to copy the file to the laptop and run
an import routine on the laptop database. It works fine enough but it is a
bit convoluted for end users (and there is room for error).

So, I was wondering if it is possible to send the data direct from the SqlCe
database on the unit to the data source on the laptop when the unit is
cradled? I don't want to use the built in Synchronise thingy of ActiveSync I
want to be able to fire the send manually when required.

Any clues? I'll be happy to fill in any missing information.

Cheers

C-Ya Aly

 

[Tom Krueger [MSFT]]

Hi there,

You are using Sql CE on Pocket PC 2003 and would like to tranfer that data
collected to another client computer.

I would check into using Merge Replication with MSDE. You will find some
information in the .NET Compaq Framework FAQ
http://msdn.microsoft.com/mobility/prodtechinfo/devtools/netcf/faq/default.aspx#9.0
and another interesting article I just found (but have not read) is "How to
Develop an Efficient Architecture based on SQL Server CE Replication
Requirements"
http://msdn.microsoft.com/library/d...s/dnppcgen/html/eff_arch_sql_servr_ce_rep.asp

Take care,

Tom Krueger
Microsoft Corporation
Program Manager
http://weblogs.asp.net/tom_krueger

This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm