ARCHIVE-TOOLS
Whatever the size of your database is you accumulate transactions day by day. At some point historical data becomes too large to keep and maintain, from a resources point of view (disks, memory), but also from a performance point of view – for example, it takes a long time to drill down to ledgers or produce reports fast. IT departments can deploy an SQL Server feature called Data Compression, but that requires the Enterprise Edition of SQL Server, and it will only deal with the disks and RAM issue, not with the quantity and heaviness of all the data in the database. Users therefore demand functionality to archive the data somewhere, still available for inspection and audit, but not clogging the operational database. For that reason, they need a product that allows them to do just that. It’s finally here. Archive-Tools from SQL Perform. Both products allow users to select what data will be shifted to a secondary historic data database on a regular basis. There are two possibilities. Perform-Archiving moves the selected data from primary to historic database whilst Perform-Compression not only moves the data, but while doing that, it also replaces the original detail ledger records with new summarized data. Imagine opening and closing balances' records are created whilst detailed data moved to somewhere else.
KEY FUNCTIONALITY OF ARCHIVE-TOOLS
Perform-Archiving
- Archive single table
- Archive pair of tables
Perform-Compression
- Compress single ledger
- Compress pair of ledgers
Perform-Dataport
- Copy a single table or pair of tables
- Copy entire Company data
Shared features
- Any NAV table handled (base/add-on/custom)
- Dimension handling
- Linked Tables handling
- Archive into a different database
- Archive into a different company
- Easy lookup to historic data
- Registers
- Un-do function
- Fast through T-SQL scripts
ADVANTAGES OF ARCHIVE-TOOLS
Small Operational Database
- Performance boost
- Faster SQL Server
- Faster drill downs in NAV
- Faster reports in NAV
- Faster processing in NAV
- Faster backups
- Faster maintenance
Fiscal and Legal Requirements
- Retain detailed data for audit and detailed inspection
- Keeping statutory data retention periods requirements cleverly
Data Visibility
- Data is kept, but it isn’t clogging the operational database
- View historic data in archive database
Audit
- Registers of archiving and compression
Un-do Functionality
- If anything went wrong, reverse to original state
Lean Infrastructure
- Less RAM and CPU power
- Minimizes need for SQL Server Data Compression
ARCHIVE-TOOLS Modules
To find out more, please follow the links below