- Knowledge Base
- Learn
- Database
-
Getting Help
-
Installation
-
Learn
- Business Activities
- Business Activity Manager
- Business Alerts
- Configuration
- Customer
- Database
- EDI
- General
- Inventory
- Manager Windows
- Mobile
- Picklists (Advanced Picking)
- Product
- Purchasing
- Purchase Order Manager
- QuickBooks & Acctivate Basics
- QuickBooks Desktop Sync
- QuickBooks Online Sync
- Reporting
- Sales
- Sales Order Manager
- Sales Tax
- Server
- Shipping
- Startup
- User Interface
- Webstore
-
Troubleshoot
-
Specs
-
How do I?
Can Acctivate data be archived or condensed?
In short, you cannot archive Acctivate data. For more info, see this article.
Acctivate does not have an archive or “purge history” function.
The Acctivate database runs on Microsoft SQL Server. The SQL Server database should accommodate the largest Acctivate users without performance degradation. Microsoft SQL Server is used by much larger Fortune 500 companies with millions of transactions. In fact, there are Acctivate customers running databases with millions of sales orders, invoices and inventory transactions.
Acctivate includes the free Microsoft SQL Server Express database server. In some cases, you may be required to upgrade to a paid version of the Microsoft SQL Server database (i.e. Standard Edition). One of the key factors in determining whether SQL Server should be upgraded is a database size limitation.
To review the limitations with SQL Express, check out this article.
Microsoft SQL Server Express Edition database limitations
Acctivate will provide a warning when you are getting close to the limitation of the free Express edition. This upgrade is typically not a significant expense for companies that have this transaction volume.