local database

[Andrea]

I need to have a local database on Pocket Pc.
I dont' want to use SQLce or Jet, because I need to upload this file
(database) on a pc or a ftp server and I dont' want to use active sync (I
use direct lan connection to upload the file (Wi-Fi or GPRS)).
I need also to download database from a web server to pocket pc.
There is some library for Net that can handle a simple single file database
and that is binary compatible with CF and NET (possibly opensource) ?

Thanks in advance,

 

[Darren Shaffer]

You can absolutely transfer a SQL CE 2.0 database file (*.sdf extension)
from your device
to a server via WIFI or GPRS. You can also pull a SQL CE database file
from a server to your device the same way. The limitation is that you'll
need
a third-party utility to access or modify the SQL CE file when it's on the
server.

With SQL Mobile coming out next year, this limitation goes away.

-Darren Shaffer

 

[Andrea]

This is the real dilemma ...
I cannot use SQL CE because when the file is on the server I have no way to
manipulate it ...
If you know of a third part managed library for NET Framework to access SQL
CE file (.sdf) ... please let me know ...
but i think is an expansive solution ...

Otherwise if someone know of somethings better than .xml or .cvs file to
store, transfer and manipulate data ... (but the amount of data is huge, so
I dont'like these 'flat file' solutions)
I think the best way is a simply managed library, compatible with CF and
NET, that can handle a simple (1 table) database file with index... but I
have not found one on the web ...

Best regards,
Thanks in advance...

 

[Darren Shaffer]

How about using SQL CE only for local data persistence and using a
replication
strategy to get your data to the server? This can be done with RDA, Merge,
or
your own web-services based strategy.

-Darren

 

[Rüdiger Kardel]

Andrea,

take a look at the sql engine from sybase
http://www.ianywhere.com/downloads/sqlany.html

it's not opensource - but the developer version is for free.
you can just copy the db-files from the pc to the ppc and vice versa.

my 5 ct.
ruediger

 

[Andrea]

Thanks for the infos ...
I cannot reach www.ianywhere.com or www.sybase.com at the moment ... (sites
seems down) but I give it a try soon.

But I think that the price is overbudget for me ... and also I'm searching
for something more simply... basically I just need some c# portable library
for handling files with records and index ... no sql, no odbc, no
replication ...
I have searched on codeproject and sourceforge but find nothing ... really
doesn't exits something like this ?

Thanks in advance,
Andrea

 

[Andrea]

Yes, but I have the trouble of installing sql ce on the device (and also
provide some way for the user to re-install it, in case of completly power
loss or cold-boot).
Another problem is that I would like to use the same database file for the
pc (a rewrite of the same pocket pc application, but used on a standard
laptop pc). Without using a server or iis on the laptop, and with the
minimum amount of configuration effort. I can do this with jet and
activesync, but when the pocket pc is out of office, they need to send data
via gprs, and activesync cannot convert the database (or there is a way to
convert a file already transferred on the pc ?).

So, if exist, I really like some 'more easy' way to store and transfer
data... just a simple file, the only things I need is an index, because
lookup a record with a complete scan of a file (about 20.000 records) is
very time consuming...
really there is no library like this on the net ? I have tried codeproject,
and sourgeforge, but found nothing ...

Thanks in advance
Andrea

 

[Ginny Caughey [MVP]]

Andrea,

I don't know if it is in your price range, but CodeBase (www.codebase.com)
should be able to do what you want.