AuditWizard - Using AuditWizard - Administration - General - Database Maintenance
(Added section "Overview") |
m (Added link to Troubleshooting) |
||
Line 1: | Line 1: | ||
<p align="right">[[File:btn_back_up.png|link=AuditWizard™ - Using AuditWizard - Administration]] [[AuditWizard™ - Using AuditWizard - Administration|<u>Back to Administration</u>]]</p> | <p align="right">[[File:btn_back_up.png|link=AuditWizard™ - Using AuditWizard - Administration]] [[AuditWizard™ - Using AuditWizard - Administration|<u>Back to Administration</u>]]</p> | ||
=Overview= | =Overview= | ||
− | This article covers the various parts of the Database Maintenance tab. | + | This article covers the various parts of the Database Maintenance tab. For a rundown of steps to remedy database issues, refer to [[AuditWizard™ - Troubleshooting - Database Maintenance|this article on troubleshooting]]. |
=Change Database= | =Change Database= |
Revision as of 02:04, 4 September 2013
Contents |
Overview
This article covers the various parts of the Database Maintenance tab. For a rundown of steps to remedy database issues, refer to this article on troubleshooting.
Change Database
You can see which database you are currently connected to in this panel. C:\Program Files\AuditWizard v8\db\aw_db.sdf is the supplied embedded database that all AuditWizard installations begin with. The format is SQL Server Compact 3.5.
The Change Database procedure is used any time you want to change to a different SQL Server database. Usually this would be when migrating from the embedded database to SQL Server.
If you are migrating from the embedded database to SQL Server, see here for instructions.
If you are changing your connection from one database to another without copying data, see here for instructions.
Database Purging
Enable or disable automatic purging. Choose individual timeframes for Asset History, Internet Records and Non-Audited Assets.
You can force a purge immediately by clicking the Purge Now button.
Import & Export
The import feature allows you to import data from a flat CSV file into the AuditWizard database. This interface was originally designed to import text files that were exported from AuditWizard v7, but most of the options may also be used to quickly create the location structure, user-defined data, and asset data. It can be useful when migrating from another application, or when a spreadsheet of data must be quickly added to AuditWizard. There are four different data import options:
Assets and Locations
Use this option to import Assets and the Location structure. An example CSV has been loaded below.
Picklists and Items
This import option allows for the import of Picklists and Picklist Items. If the Picklist already exists, then the Items will be imported into it. If the Picklist does not yet exist, then it will be automatically created.
User Defined Data Fields
Use this import feature to import user-defined data values. If the fields have already been configured in User Defined Data, then the values will be imported into them as defined. If the fields do not yet exist, then they will be automatically created. An example CSV file has been loaded below.
Asset History Data
This is used to import asset history data that was exported from AuditWizard v7.
Database Maintenance
Support may issue a query to repair or maintain your database. This interface is provided for convenience so that you don't have to leave AuditWizard to run the query in Management Studio. The query will be intended for one-time use.
Click the button to open the AuditWizard Database Maintenance dialog:
If Support has supplied you with a .sql file, click the Load SQL button, locate the file and load it. This will populate the SQL statement field. If you have been given a query in plain text via email, copy and paste it into the SQL statement field. Click the Run SQL button to run the query.