Solved

SQL Server database synchronization

Posted on 2014-04-08
6
411 Views
Last Modified: 2014-04-11
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.
0
Comment
Question by:koossa
  • 3
  • 3
6 Comments
 
LVL 25

Expert Comment

by:jogos
ID: 39985960
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
 

Author Comment

by:koossa
ID: 39988161
Thank you Jogos.
Is there any way to do the synchronization automatically or will I have to do it manually?
0
 
LVL 25

Assisted Solution

by:jogos
jogos earned 500 total points
ID: 39988352
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
Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

 

Author Comment

by:koossa
ID: 39988357
What about replication?  Will it be possible to replicate from the Server to a Mobile version of SQL Server?
0
 
LVL 25

Accepted Solution

by:
jogos earned 500 total points
ID: 39993682
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
 

Author Closing Comment

by:koossa
ID: 39993800
Thank you
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
This article shows how to deploy dynamic backgrounds to computers depending on the aspect ratio of display
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now