Re: Send data through ActiveSync
From: Tom Krueger [MSFT] (a-tkrueg_at_online.microsoft.com)
Date: 05/28/04
- Next message: Yechezkal Gutfreund: "Re: TCP Socket doesn't recognize line interruption"
- Previous message: Keith: "Re: Instrumentation widgets / gadgets for CE .Net 4.2"
- In reply to: Mystic Mong: "Send data through ActiveSync"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 28 May 2004 13:42:23 -0700
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/default.asp?url=/library/en-us/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
"Mystic Mong" <alastair.williamson@tiso.co.uk> wrote in message
news:40b78fd7$0$4593$db0fefd9@news.zen.co.uk...
> 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
>
>
>
>
>
- Next message: Yechezkal Gutfreund: "Re: TCP Socket doesn't recognize line interruption"
- Previous message: Keith: "Re: Instrumentation widgets / gadgets for CE .Net 4.2"
- In reply to: Mystic Mong: "Send data through ActiveSync"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
