Thursday, January 28, 2016

Rental Record Archive Option

An option has been added to ZonePro that allows users to move older records out of the Rental database. The old records are then stored in an archive database that is created just for that purpose. To use this option you would go to the ZP Toolbox screen and click on the SQL Archive Utility button. A new tab has been added here for Rental records. It only selects records that were entered at least five years ago and have a Rental Status of "Archive." These records can then be pulled out of the main database and stored in a new one. The benefit of using this tool is really just reducing the size of the Rental database and thereby speeding up report operations and other activities that sift through the full set of records. The downside is that you are removing records that may be of historical interest.

No comments:

Post a Comment