SQLCE and desktop MSSQL synch through gprs

  • Thread starter Thread starter Noram Noram via DotNetMonster.com
  • Start date Start date
N

Noram Noram via DotNetMonster.com

Could you help me to start a project about remote SQL. We are programming
SQL CE in VB .NET.
The task is simple, we have to synchronize an SQL CE (with a gprs enabled
PDA) with a desktop MSSQL. We are familiar both with SQLCE and standard
SQL, but how to start with GPRS synch?
Is the synch through internet or the desktop server should have an USB gprs?
Does VB.net have gprs dll? Do you have some experiance or something that
could help us?

Many thanks!
Noram
 
Noram,

If you plan to use either of the built-in data synchronization technologies
that are supported by SQL Server CE (Merge Replication or Remote
Data Access), they both use http as their transport mechanism for the
synchronization, so whether you are using GPRS, 802.11x, or
dialup, you can achieve synch with these technologies. When you
attempt to architect a system that will sync over GPRS, you have a
couple of challenges - the first is the bandwidth of the connection
which is typically no more than 40kbps. This means you have to
carefully consider what data needs to be synchronized and also
understand the differences between Merge and RDA in terms of
network traffic.

Use Google advanced groups search on microsoft.public.sqlserver.ce
to get more information on this topic.
--
Darren Shaffer
..NET Compact Framework MVP
Principal Architect
Connected Innovation
www.connectedinnovation.com
 
Back
Top