dkmarsh
asked on
asp.net tablet application - local database with central sql server 2008 and replication
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 ?
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 ?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.