asp.net tablet application - local database with central sql server 2008 and replication
Posted on 2009-05-16
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 ?