I would appreciate expert suggestions for the best strategy about updating solutions.
For a number of reasons, my solution is made of:
- 1 MAIN file with Tables for a total of some 700.000 records (number increases daily)
- 2 Accessory files of 1 Table each
Since I perform updating of the solution using scripts in sequential order, what would be the best practice for updating the MAIN file solution ?
A- rename the older file ?
B- keep the old file with the same inside a folder within the new solution file ?
C - use a specific strategy ?
Or in general, is there a guideline (that I didn’t find) for avoiding errors and producing the fastest reliable result ?
Thanks for all the suggestions,