Solved

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

Posted on 2009-05-16
1
420 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
[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
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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…

729 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