Keystone Support Backup

Purpose

This utility is used to strip out non-essential data when making a backup of a customer's database for purposes of diagnosing an issue. It can be used with any version of Keystone.

Operation

The Keystone Support Backup utility does the following:

• Restores an empty master company database as a temporary database
• Analyzes the desired tables and automatically adds missing dependent tables
• Pumps the data from the customer's database to the temporary database in proper dependency order
• Backs up the temporary database to a file of your choosing

Backups made using this utility may be restored like a normal company backup from the Keystone System Maintenance menu.

Be careful never to restore this backup on a customer system!

Download

Download link: Keystone Support Backup

Example

Suppose you want to make a backup of a customer's database, but you're only interested in A/R tables and you don't need the A/R history tables. When you run the utility, enter the following as shown below:

• For Database Name browse to the company database file that you want to backup by clicking the ellipsis button
• For Company Name enter a description to be stored in this backup
• Check the box next to "AR" in the Tables list

Error creating thumbnail: /bin/bash: /usr/bin/convert: No such file or directory Error code: 127

Now click the '+' next to AR. This will expand into a list of all the A/R tables, and all the A/R tables will be checked. Now uncheck the A/R history tables as shown below:

Error creating thumbnail: /bin/bash: /usr/bin/convert: No such file or directory Error code: 127

Finally click the 'Backup' button and the utility will start. It may take some time depending on how many tables are selected and how much data the tables contain. A status message just to the left of the 'Backup' button will let you know what is happening. When the backup is complete you will see a message to that effect.