importing data into a sqlce20 database

  • Thread starter Thread starter Milsnips
  • Start date Start date
M

Milsnips

hi there,

i've got an app that imports roughly 10000-15000 records of master data
which needs to be sync'd daily. Currently i'm using WLAN or GPRS to connect
to remote SQL database, then get a populate a sqlDataReader and as i loop
through remote data, i insert it into local.

This can take up to 6-10 minutes which i was wondering if its possible i can
speed this up. i've looked into replication and find it a bit complicated in
having to configure it for each customer rollout i do.

Any advice on speeding up the data import would be appreciated.

thanks,
Paul
 
Paul,

You might check out the products at http://www.primeworks-mobile.com/. I
don't know if that would be faster, but I suspect that it might.

If you could upgrade from SqlCE 2.0 to SQL Mobile, of course you could
massage the data on the desktop machine and just copy the SDF file to/from
the device, and that would be faster.
 
yep good point, thanks for the advice. I also considered the option of
generating the file on desktop, compressing and sending to device, i think
it could be faster.

Will also have a look at the link you sent too to see if it helps out.
thanks,

Paul
 
Back
Top