SQL Server database synchronization

I need to setup a SQL Server database on a server with a couple of handheld windows mobile devices.
Some of the updates will be done on the server and some of it on the Windows Mobile devices.
Is there any option to do database synchronization so that all the data be up to date on the server and mobile devices without consuming too much bandwidth.

It will sometimes be done using Wi-Fi and other times 3g / HSDPA.
koossaAsked:
Who is Participating?
 
jogosConnect With a Mentor Commented:
Synchronisation is more flexible and will synchronize the data at the state it is in, not the 30 tranactions that took it to bring it there.

Choosing
http://msdn.microsoft.com/en-us/sync/cc470041.aspx\
Differences
http://pervasync.wordpress.com/2011/08/17/server-centric-pervasive-computing-and-data-synchronization/
0
 
jogosCommented:
The first effort is to limit the data to be exchanged.
As less tables as possible, not bi-directional when not needed.
Consider table-definiton , every updatable-column can trigger the whole row to be processed, so a table with many non essential columns will be heavier to synchronize.
0
 
koossaAuthor Commented:
Thank you Jogos.
Is there any way to do the synchronization automatically or will I have to do it manually?
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
jogosConnect With a Mentor Commented:
Databases won't synchronize automaticaly. You have to define synchronisation

More documentation about the sync framework that does that is made for that
http://msdn.microsoft.com/en-us/sync/bb821992.aspx
http://msdn.microsoft.com/en-us/sync/bb736753.aspx
0
 
koossaAuthor Commented:
What about replication?  Will it be possible to replicate from the Server to a Mobile version of SQL Server?
0
 
koossaAuthor Commented:
Thank you
0
All Courses

From novice to tech pro — start learning today.