Fully Tested
and Supported


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.






  • Archive single table
  • Archive pair of tables


  • Compress single ledger
  • Compress pair of ledgers


  • 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

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


  • 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

To find out more, please follow the links below