Re: Alternatives to SQL Server Mobile?

Other options to look at are DB2e for the device and Intellisync for the
sync infrastructure. DB2e is probably the best device database but its not
free. Intellisync offers robust database sync between SQL Mobile, Sybase ASA
or DB2e on the device and pretty much any back end database or application.

Andrew Grillage
www.intellisync.com


"BuddahDog" <google@xxxxxxxxxxx> wrote in message
news:1138375274.239916.61970@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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


.

Relevant Pages

  • Re: Wireless Synchronization
    ... desktop database and PPC database. ... Directly Querying SQL Server using SqlClient (Bit Slow while ... Web Services ... Services as the sync option. ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: Good Books on SQL Server Mobile
    ... the only book out so far specific to SQL Server Compact Edition is Bill Vaughn's eBook: http://www.hitchhikerguides.net/EBooks/default.aspx Recent books on general mobile development topics also tend to have a chapter or two covering SQL Mobile. ... You can create databases programmatically, and you can also use SQL Server Management Studio to create SSCE databases, test querires, etc. ... I tend to use Management Studio during development while I'm designing the database, but my apps that use SSCE always have the ability to create those databases as needed by the time they're production ready. ... In most cases for me that's a desktop app that creates the database and pushes the data down to the device, but increasingly I'm using SQL Compact for purely desktop apps for local data storage. ...
    (microsoft.public.sqlserver.ce)
  • Re: Good Books on SQL Server Mobile
    ... Hitchhiker's Guide to Visual Studio and SQL Server ... Management Studio during development while I'm designing the database, ... desktop app that creates the database and pushes the data down to the ... I copy the SQL Mobile cab file to devices in my ...
    (microsoft.public.sqlserver.ce)
  • Re: Alternatives to SQL Server Mobile?
    ... database extensively and was told by a colleague that DB2e was better. ... I must humbly disagree about DB2e. ... Intellisync offers robust database sync between SQL Mobile, ... >> However the app is NOT SQL Server based, ...
    (microsoft.public.pocketpc.developer)
  • Re: Good Books on SQL Server Mobile
    ... the only book out so far specific to SQL Server Compact ... mobile development topics also tend to have a chapter or two covering SQL ... desktop app that creates the database and pushes the data down to the ... installation/data extractor desktop app, but you can also just copy the SQL ...
    (microsoft.public.sqlserver.ce)
Quantcast