Re: New to Windows CE Development - Have some questions
- From: "Paul G. Tobey [eMVP]" <ptobey no spam AT no instrument no spam DOT com>
- Date: Wed, 19 Oct 2005 12:25:53 -0700
You'd have to write code. If all you are doing is collecting data, *never*
validating against the main database, or querying the database during data
collection, you can just store your data always in SQL CE and, when
connected, iterate through the SQL CE table and create new entries in the
SQL Server database that correspond. You have to do that yourself.
Double-check those requirements, though. It's a pretty unusual data
collection application that has no verification of the data and never wants
to modify, only add, rows to database tables...
Paul T.
"Nikos_Pontios" <NikosPontios@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:16BF94BF-837B-48E4-A58A-146AB6A7927E@xxxxxxxxxxxxxxxx
> Hello Paul,
>
> Thank you so much for your time and effort to reply to all my questions.
> You said:
> For your synchronization question, yes, trying to push SQL CE data into
> Sybase or Oracle in only one direction won't be a problem.
> I say:
> So, when I connect my device back to the Enterprise either via the
> wireless
> or USB I can use some feature of SQL Server CE to push records from the
> local
> SQL Server CE table to a Sybase DB via ODBC? I would not have to write any
> code to do this?
>
> "Paul G. Tobey [eMVP]" wrote:
>
>> As you might imagine, 'what's different between WM and CE?' gets asked
>> constantly. Remember that Google archives all messages to the group.
>> You
>> can search here:
>>
>> http://groups.google.com/group/microsoft.public.dotnet.framework.compactframework?hl=en&lr=lang_en&ie=UTF-8&oe=UTF-8
>>
>> 3. You might imagine that Pocket PC and SmartPhone are configurations of
>> the
>> OS which pull in some features and leave out others. The list of
>> features
>> pulled in is defined by MS and is called Windows Mobile 5, say, for
>> PC. Each PPC vendor can customize further, of course, but the same basic
>> set of components from the OS menu is in each one.
>>
>> As with Windows Mobile 5, Windows Mobile 3, means one of SmartPhone 2003
>> or
>> Pocket PC 2003. That is, "Windows Mobile" is a generic way of referring
>> to
>> both SP and PPC.
>>
>> As far as your application, you probably *can* use either C++ and
>> unmanaged
>> code or VB.NET or C# and managed code. Most of the probable target
>> devices
>> run the same processor type, so your EXE would likely work on most of
>> them.
>> Whether unmanaged or managed code is right for you will depend on the
>> *specific* list of targets and, as you say, your own expertise.
>>
>> For your synchronization question, yes, trying to push SQL CE data into
>> Sybase or Oracle in only one direction won't be a problem, but merge
>> replication with one of those is not implemented at all, as far as I
>> know,
>> so you'd have to detect what changed on both ends when you tried to
>> synchronize and figure out what to do about it. This is a big job (merge
>> replication setup on SQL Server is a big job, too, but small compared to
>> supporting an arbitrary list of databases).
>>
>> When connected, you *could* use RDA to do your database I/O, however,
>> because you *are* going to be disconnected at times, you'd have to be
>> incredibly careful about what's in the local database, so you don't use
>> wrong data!
>>
>> Paul T.
>>
>> "Nikos_Pontios" <Nikos_Pontios@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
>> message
>> news:A153021E-4226-4628-99E9-68CC7104A806@xxxxxxxxxxxxxxxx
>> > Hello,
>> >
>> > I have been a developer for 12 years but I am new to Windows CE
>> > development.
>> > First, I would like to ask a simple question: What is the difference
>> > between
>> > Windows CE and Windows Mobile?
>> > Based on some reasearch that I have done this is what I found:
>> > 1. Windows CE 3.x is the base for Pocket PC 2002 and SmartPhone 2002
>> > 2. Windows CE 4.x is the base for Pocket PC 2003 and SmartPhone 2003
>> > 3. Windows CE is the operating system and Pocket PC/SmartPhone is a
>> > platform
>> > based on Windows CE. Is a platform a different flavor of the OS?
>> > I get a little bit confused when I see something like this: "However,
>> > the
>> > Smart Device Programmability features of Visual Studio .NET 2003 allow
>> > developers to debug the .NET Compact Framework 1.0 applications on
>> > PC
>> > 2002, Pocket PC 2000, Windows Mobile-based devices, and Windows Mobile
>> > 2003
>> > Second Edition-based devices."
>> > What is Windows Mobile and Windows Mobile 2003 Second Edition?
>> >
>> > I also need some quidence on the following scenario:
>> > 1. I have an Intermec 751G device with Windows CE .NET 4.2. The device
>> > has
>> > a
>> > wireless card but it can also connect via USB through the cradle.
>> > 2. I need to build an application for the device that can work even
>> > when
>> > you
>> > are
>> > not connected to the Enterprise. The application needs to download
>> > reference
>> > data, capture new data and upload the new data to the Enterprise. If
>> > the
>> > device
>> > is connected to the Enteprise we are doing everything real-time. If
>> > the
>> > device
>> > is not connected to the Enterprise we are storing everything locally
>> > until we
>> > connect back to the Enterprise. When we do connect back to the
>> > Enterprise we
>> > then synchronize the data between the device and the Enterprise.
>> > 3. The application needs to have the flexibility to work on other
>> > devices
>> > without any
>> > major rework. Based on my research, I need to develop in managed
>> > code.
>> > right?
>> > 4. I need to develop this application as soon as possible so I was
>> > thinking
>> > to use
>> > VB .NET since my prior experience has been with fourth generation
>> > languages. I
>> > have worked with Sybase PowerBuilder.
>> > 5. I currently have Microsoft Visual Studio .NET 2003 Enterprise
>> > Architect
>> > and I
>> > can not spend any more money for software. I also have a license
>> > for
>> > SQL
>> > Server 2000 Enterprise Edition.
>> >
>> > I was thinking to use the following when the device is:
>> > 1. Disconnected from the Enterprise: Use SQL Server CE on the handheld
>> > to
>> > store
>> > transactions locally. Once you are connected back to the Enterprise
>> > either via
>> > wireless or USB(cradle) use Merge Replication between SQL Server CE
>> > and
>> > SQL
>> > Server 2000 Enterprise Edition. If I wanted to work with another DB
>> > Engine
>> > (Sybase or Oracle) do I have to write an application that will read
>> > from
>> > the SQL
>> > Server CE and synchronize with Sybase or Oracle?
>> > 2. Connected to the Enterprise via Wireless: Use ADO.NET or RDA to
>> > capture
>> > the
>> > transactions real-time in the Enterprise.
>> >
>> > I know it's a lot of questions but please try to help a beginner that
>> > is
>> > very eager to learn. I have done a lot of research but there is so much
>> > information out there that becomes hard to put everything together and
>> > make
>> > some sense out of it.
>> >
>> > Thanks in Advance
>>
>>
>>
.
- References:
- New to Windows CE Development - Have some questions
- From: Nikos_Pontios
- Re: New to Windows CE Development - Have some questions
- From: Paul G. Tobey [eMVP]
- Re: New to Windows CE Development - Have some questions
- From: Nikos_Pontios
- New to Windows CE Development - Have some questions
- Prev by Date: New at CE: can't launch an application at startup
- Next by Date: Re: New at CE: can't launch an application at startup
- Previous by thread: Re: New to Windows CE Development - Have some questions
- Next by thread: Re: New to Windows CE Development - Have some questions
- Index(es):
Relevant Pages
|
