Solved

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

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

This is basically a blog post I wrote recently. I've found that SARGability is poorly understood, and since many people don't read blogs, I figured I'd post it here as an article. SARGable is an adjective in SQL that means that an item can be fou…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
In this video I am going to show you how to back up and restore Office 365 mailboxes using CodeTwo Backup for Office 365. Learn more about the tool used in this video here: http://www.codetwo.com/backup-for-office-365/ (http://www.codetwo.com/ba…

910 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