Solved

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

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

Title # Comments Views Activity
sql query questions 2 41
MS SQL Server Modify insert/update update to use MERGE 13 53
Find results from sql within a time span 11 45
Stored Proc - Rewrite 42 56
I have written a PowerShell script to "walk" the security structure of each SQL instance to find:         Each Login (Windows or SQL)             * Its Server Roles             * Every database to which the login is mapped             * The associated "Database User" for this …
If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

791 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