WE currently have a VB6 app that uses SQL Express 2005/2012 as the backend on remote laptops(currently 1000+ machines). The app currently uses a VPN connection to connect to a SQL Server box at corporate to "replicate" data up and down thru SPs and ADO. We are starting the process of upgrading to .Net for this application and we are looking at options
Option1) Leave it the same. Make the users connect to the VPN and again use SPs and ADO.Net to "replicate" the data.
Option 2) Take the VPN out of the equation. and use HTTPS with a web service to send the data down via XML to the remote machines. My confusion is how would I use this process to send data up thru the web service.
Not necessarily looking for code, but larger overview of if Option 2 is possible and the best place for reading or examples.
TIA
Dave
Option1) Leave it the same. Make the users connect to the VPN and again use SPs and ADO.Net to "replicate" the data.
Option 2) Take the VPN out of the equation. and use HTTPS with a web service to send the data down via XML to the remote machines. My confusion is how would I use this process to send data up thru the web service.
Not necessarily looking for code, but larger overview of if Option 2 is possible and the best place for reading or examples.
TIA
Dave