September 24, 2009 at 8:19 am
I'm planning on creating a web application which allows people to create, complete, edit and delete risk assessments on various subjects i.e. manual handling, fire, COSHH etc.
I'll be creating the database with SQL Server 2005 Express Edition and the application with Visual Web Developer 2008.
Now my question - Would I also be able to create an application for a mobile device such as a mobile phone which the assessor can use to complete the assessment after which the details are sent to the database? or would I have to use SQL Server Compact Edition. Or do I need both? I hope this question makes sense.
Any advice would be appreciated.
Marley
September 24, 2009 at 8:30 am
It depends whether the mobile device is connected to the internet?
If so I would use one central database and develop custom pages that can be viewed in the mobile device over the internet and all the data can be saved to a central location.
If the devices are disconnected then you can use SQL CE on each device and implement some form of merge replication to synch up the data when the device is connected.
If possible the first option would require the least amount of work,
September 24, 2009 at 10:47 am
Thanks for the quick reply and advice, I think like you said the first option would be best. Also since more and more mobiles come wap enabled the connecting to the internet won't be a problem.
Anyway thanks again for your help.
Marley
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply