Solved

SQL Server database synchronization

Posted on 2014-04-08
6
421 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Webinar: Aligning, Automating, Winning

Join Dan Russo, Senior Manager of Operations Intelligence, for an in-depth discussion on how Dealertrack, leading provider of integrated digital solutions for the automotive industry, transformed their DevOps processes to increase collaboration and move with greater velocity.

 

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

Business Impact of IT Communications

What are the business impacts of how well businesses communicate during an IT incident? Targeting, speed, and transparency all matter. Find out more in this infographic.

Question has a verified solution.

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

Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

728 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