Would like a Data Archiving Utility for all Viewpoint products - Primarily VPC and Vista. Business Impact: Slowness of server due to too much data and docs accumulated historically. Daily backups now take forever. Would like to be able to archive data and docs that are older than a certain period. |
Company | Bird construction Company LTD |
Dear Viewpoint Suggestion Box contributor;
We at Viewpoint sincerely thank you for your contribution to Suggestion Box on how we can improve Viewpoint products. While we can’t do everything at once, we rely upon your feedback to help guide the prioritization of our product improvements, and Suggestion Box is a critical tool for us to understand and prioritize our customers’ needs.
Viewpoint reviews Suggestion Box regularly for all of our products and updates statuses, adds comments, and performs various house-keeping (including deleting) as needed to ensure that Suggestion Box is maintained as a productive environment for product enhancements requests.
© 2023 Trimble Inc. All Rights Reserved. Viewpoint®, Vista™, Spectrum®, ProContractor™, Jobpac Connect™, Viewpoint Team™, Viewpoint Analytics™, Viewpoint Field View™, Viewpoint Estimating™, Viewpoint For Projects™, Viewpoint HR Management™, Viewpoint Field Management™, Viewpoint Financial Controls™, Vista Field Service™, Spectrum Service Tech™, ViewpointOne™, ProjectSight® and Trimble Construction One™ are trademarks or registered trademarks of Trimble Inc. or its affiliates in the United States and other countries. Other names and brands may be claimed as the property of others.
The reason why I suggest two databases is so the data is still easily accessible. We don't want to have to run a new program, or a utility to find 1 document.
I don't know if it's currently able to be done, but the ability to select multiple database servers, so you could have all the archive items moved to one server so that can be backed up monthly etc, then an active one. So you could say after database reaches x amount, transfer first z amount of data to the archive server. That would keep the newest relevant data on the primary server and only once in a while will the data be moved to the backup server.
Data archiving is a great idea and something we've already started investigating, but we need to make certain to do it right, without putting data at risk.
Great idea. This is a major issue for us. Our attachment DB is currently 1.16TB and our transaction DB is 120GB. An archive utility would be a life saver