I will have a .net application that stores data for payments
There are 3 + sites that all run the same desktop app
Every day, and backup will need to be done onto USB drive.
All 3+ sites hand their USB drive to the boss, and he then will need to import all data onto his computer running the same application
this computer will generate reports on the data
however, i'm really unsure how to do the backup/import
the data structure is the same, and they are all running the same software, but will be collecting different data
all this data will need to be merged every day manually,
I dont want the user to interact with SQLserver directly..... the .net application will have to do this
can someone suggest an approach of how i export and import the data with getting data integrity issues?