Archiving Paste Equipment Data
Hi all, I'm thinking of archiving all past equipment and just wondering if anybody have any better suggestions as to what i'm thinking. 1. Creating a duplicate App, then setting up automation to...
Forum Discussion
HI Samual,
Why would you waste another app just to keep archived data and burry the performance of other apps. The best practice is to agree and set the retention period for your data as QB limits only 500mb data per table. Take a dump in csv or use the database like (SQL, MYSQL Server) to keep a archive. If you have db sitting on cloud, you can quickly get the data archive using zapier or workato. If you want to do it offline, use the QuNect connector by which you can archive on sql server. It also comes with QuNect backup utility which archives the whole app or report based data including file attachments.
Hope this helps.
------------------------------
Babi Panjikar
------------------------------
Why would you waste another app just to keep archived data and burry the performance of other apps. The best practice is to agree and set the retention period for your data as QB limits only 500mb data per table. Take a dump in csv or use the database like (SQL, MYSQL Server) to keep a archive. If you have db sitting on cloud, you can quickly get the data archive using zapier or workato. If you want to do it offline, use the QuNect connector by which you can archive on sql server. It also comes with QuNect backup utility which archives the whole app or report based data including file attachments.
Hope this helps.
------------------------------
Babi Panjikar
------------------------------