Solved

asp.net tablet application - local database with central sql server 2008 and replication

Posted on 2009-05-16
1
411 Views
Last Modified: 2012-06-27
Hi. I have built an application that has a central sql server 2008 database.

A user that accesses the application via tablet PC is having intermittant connectivity problems accessing the central database with their mobile connection (using mobile broadband).

I want to create a local copy of the application and database on the tablet so that they can use the application locally and then transmit the data to a central server when they choose.

I am looking at using SQL Server replication and having a local SQL server express 2008 or SQL compact edition.

Can you please let me know if you have setup a similar solution. - if so - was it straight forward or did you have lots of challenges ?

Did you use SQL Server express 2008 or SQL compact edition on the tablet ?
Is sql server replication solid and reliable or are there lots of problems ?


0
Comment
Question by:dkmarsh
1 Comment
 
LVL 31

Accepted Solution

by:
RiteshShah earned 500 total points
ID: 24402027
you actually need Microsoft Sync Framework for your need.

have a look

http://msdn.microsoft.com/en-us/sync/bb821992.aspx

http://msdn.microsoft.com/en-us/sync/default.aspx

0

Featured Post

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

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

Suggested Solutions

     When we have to pass multiple rows of data to SQL Server, the developers either have to send one row at a time or come up with other workarounds to meet requirements like using XML to pass data, which is complex and tedious to use. There is a …
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.

770 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