Require Web Services to send data from head office SQL Server database on Amazon AWS cloud to iPad, then to receive updates back from iPad.
Get Configuration (6 database tables): iPad receives Configuration data in JSON. Used initially on new iPad, then occasionally when head office updates Configuration.
Get Jobs (3 database tables): iPad sends either Job / Property or date range, plus User's email and password, receives back Job data for jobs scheduled in data range (normally today) for this User in JSON.
Send Updates: iPad sends updated Job and Configuration data in JSON, Web Service updates head office SQL Server (4 database tables).
Note: There is an existing Web site written in ASP.NET, Visual Basic. It is used to display schedule of jobs and update database. There is also an example Web Service using Visual Studio Connected Service which can be provided, presently has no authentication and not using JSON which is required.
See attached Specification which includes SQL to select data, MSSQL Server 2014 Express database will be supplied with UPDATE SQL examples.