How to archive data to a new database

This feature archives transactional data to a new SQL Server database. This utility prompts the user for a date range, an archive folder and the type of data (logs, rentals, transactions, etc.) to archive. Records in various tables that match these criteria are then copied to new .dbfs in the archive folder, and deleted from the main tables.

Warning: As with all data maintenance, please contact Siriusware Technical Support if you do not understand the function of this button, or are unsure if you need to use it.

1. Go to SysManager > Utilities > Data Maintenance.

2. Select Archive Data to a New Database.

3. Input the data range for data that needs to be archived.

4. Under Archive Folder select or create a folder to store the archived data.

5. Under Type of Data to Archive, select one, several, or all the items by checking the boxes. Or use the Select All button to select all the items.

6. Click Go.

The following is the list of tables that are archived per item in the Type of Data to Archive box:

1. Type = Activity Logs includes:
- acc_log.dbf
- access.dbf/fpt
- gst_actv.dbf/fpt
- gst_log.dbf
- msg_log.dbf/fpt

2. Type = Bookings includes:
- b_histry.dbf
- b_sched.dbf/fpt

3. Type = Inventory includes:
- i_invent.dbf

4. Type = Rentals includes:
- r_entals.dbf
- r_header.dbf/fpt
- r_hist. dbf/fpt

5. Type = Payroll includes:
- p_ayroll.dbf/fpt
- p_manadj.dbf/fpt
- p_sched.dbf

6. Type = Sales Transactions includes:
- sale_hdr.dbf
- sh_save.dbf/fpt
- tr_save.dbf/fpt
- transact.dbf

Note: Any sales and saved sale transaction records that are linked to unfinalized invoices are not archived, even if they fall in the date range.