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?
 
jogosCommented:
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
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
jogosCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.