Explain the process of Data Archive

How to archive a data base?

Archive Data screen is used to move all the transaction data to a new database. It allows you to move old data to archive data. The old data is broken in Quarter-wise (3 - months) and after completion, they are compressed to avoid performance issues. After completion of the Archive process, the data available in the new database has read-only permission, you can view the data but you will be not able to edit it.

The Archive Data comprises of:
Important Notes:
  • Data once the move cannot be reverted back to the main database.
  • Once data is archived, it will be available in the history database.
  • For the Starter and Standard edition, it is available with a custom license only.
  • Use the following SQL database based on the following data storage limit:
    • SQL 2005  (Express edition) - upto 4 GB data
    • SQL 2005 (Standard edition) - unlimited data
    • SQL 2008 (Express edition) - upto 8 GB data
    • SQL 2008 (Standard edition) - unlimited data
  •  It is not recommended to do a purge process in counters at peak business hours because when the purge process will start, the system would not be able to save the bills.
  • For VSS  customer Data Purge is not possible.

Limitations:
  • For the Archive Data process, a minimum of 3 months of transaction data required is required.
  • The Archive Transaction (Medishopdb (Production Live Data)) and Archive Audit (RposAuditDB) is available with Archive Data only but not available with Archive Trac (RposTracDb).

    • Related Articles

    • How to Archive Audit Report Data on your RPOS6 DB (RposAuditDB)?

      Right-click the GoFrugal RPOS6 icon. Click Properties. The GoFrugal RPOS6 Properties screen is displayed. Click Open File Location. The GoFrugal RPOS6 file location folder is displayed. Double-click the ArchiveData.exe icon. The Archive Database ...

    • How to Archive your Transaction Data from your RPOS6 DB (Medishopdb)?

      Steps for Archive Data - Archive Transaction (Medishopdb (Production Live Data)) Right-click the GoFrugal RPOS6 icon. Click Properties. The GoFrugal RPOS6 Properties screen is displayed. Click Open File Location. The GoFrugal RPOS6 file location ...

    • What is Data Purge?

      Data Purge Data purge is the permanent deletion of the unwanted/old data. Purge process is ideal for customers who want to manage their storage (disk space) or database size efficiently by permanently deleting the data that is no longer required by ...

    • Do you know how to setup Item vs Base/Sub UOM in RetailEasy?

      What is the purpose of Item vs Base/Sub UOM? Use Item vs Base/Sub UOM screen to map the items against the UOM for multi-item. For e.g. One business has different items (e.g. Sugar and Cake) but with same UOM, such items can be mapped at a time with ...

    • How to map Data to Barcode?

      Barcode Data Mapping Barcode Data Mapping is a technique for mapping the data in the form of barcode. These mapped barcode data are printed on sticker through the Barcode Printer and scanned through the Barcode Scanner. In RPOS 6, you can configure ...