Re: Alternatives to SQL Server Mobile?
- From: "BuddahDog" <google@xxxxxxxxxxx>
- Date: 27 Jan 2006 07:21:14 -0800
As an alternative, look into Sybase ASA and their Mobilink
synchronization product. It is by far the most robust mobile DB
solution on the market, and it will address many of your issues -
especially the ability to sync with non-SQL Server db's on the back
end. It's somewhat costly compared to, well, free, but it's worth it
if you're developing an enterprise mobile app that needs features of a
"real" database on the mobile side.
-BDog.
Déjà-vu wrote:
> Hello everybody,
>
> I am totally new to Wiindows Mobile programming. As far as palm sized
> computers are concerned, I exclusively coded for Palm OS so far. We now
> want to move our app to Windows Mobile (5.0), so I try to get used to
> all the new documentation and stuff.
>
> From reading the docs and the various newsgroups, I figure that there
> are some restrictions using SQL Server Mobile which I want to check, so
> please help me, if I got things right or wrong:
>
> ** Due to the 8k Page Size, SQL-Server Mobile has a row size limit of
> 8060 bytes. This means that I can't use too many VARCHAR type fields in
> a table because I might hit the limit. (Right or wrong?)
>
> ** What are the pros and cons of spreading VARCHAR fields over multiple
> tables. (Assume table FOO with so many columns that it would hit the 8k
> limit is split into FOO1 and FOO2 in order to overcome the limit)
>
> ** What is the purpose of type 'NTEXT'? Is it meant to overcome the 8k
> limit?
> The docs say "NTEXT is no longer supported in string functions". Does
> that mean, I can't use such a column for an ORDER BY or inside a WHERE
> clause?
>
> ** How about performance and memory usage? Because of the nature of my
> application I have a rather large number of records (in certain cases
> >32k records) usually containing <1k of data.
>
> ** Naturally I have to sync my data with our desktop application.
> However the app is NOT SQL Server based, so neither RDA nor Merge
> Replication nor XML-Based IIS Services are an option.
> Is it possible to write an ActiveSync module that will connect to the
> SQL Server Mobile DB on the Device in order to perform synchronisation?
> (Since I don't have an option, I don't mind going a bit deeper into it)
>
> ** I haven't got too much into the ActiveSync docs yet. What is the deal
> with calling CeRapiInvoke? Is it possible to use this in order to
> develop a complete own synchronizing logic (and still use SQL Server
> Mobile)?
>
> ** From what I figured, coding SQL Server Mobil with OLE DB is a bit of
> a pain. Are there good wrappers for use with C++? (but not necessarily
> bound to MFC, as )
>
> ** What other SQL DB engines would run with Windows Mobil 5.0? I am
> asking, because I am not (yet) bound to use SQL Server Mobile for my
> application. I saw a few references to SQLite. Are there others?
> (I would prefer an SQL DB engine, because of relations and the power of
> indices and WHERE clauses and so forth)
>
>
> ** I haven't decided yet whether to user C# with .NET Compact Framwork
> or C++ with either MFC / WTL / Win32 yet. Is it possible to mix parts of
> it. For some GIS rendering stuff I would prefer native C++ because of
> speed. For some DB GUI stuff, I figured, it could be easier to use .NET
> / C#?
> What are the pros/cons?
>
>
> LOTIA (lot of thanks in advance)
>
> Tilman
.
- Follow-Ups:
- Re: Alternatives to SQL Server Mobile?
- From: Andrew Grillage
- Re: Alternatives to SQL Server Mobile?
- References:
- Alternatives to SQL Server Mobile?
- From: Déjà-vu
- Alternatives to SQL Server Mobile?
- Prev by Date: Pocket IE - basic authentication problem
- Next by Date: Re: OpenNETCF 2.0 Graphics
- Previous by thread: Alternatives to SQL Server Mobile?
- Next by thread: Re: Alternatives to SQL Server Mobile?
- Index(es):
Relevant Pages
|
