Solved

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

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

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL Server Results to Excel File 18 73
tempdb log keep growing 7 43
Index and Stats Management-Specific tables 8 38
Need return values from a stored procedure 8 40
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…
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 …
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

679 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