Software was written to copy rows from the tables in the Azure database to a local copy of SQL running on a users machine. The copy logic is based on the last update date in each record in the Azure database. This is done from the following screen:
The backup buttons are clicked to start the respective copies, and the number of records affected is added to the open boxes as the backups are completed.
The local PC needs to be running a copy of Microsoft SQL and Microsoft SQL Server Management Studio.
An alternative backup method is provided for the less technical user. The four SQL tables can be written to one Excel file, with each table in a different workbook. Using this Excel file, a qualified tech one could re-create the SQL tables or Access tables.