Database Preferences Page

<< Click to Display Table of Contents >>

Database Preferences Page

The Database settings allow you to manage the PDQ Deploy database.

To access the Database settings page, click File > Preferences (or press Ctrl+Comma) and select Database in the Preferences window.

Options

Description

Database

Shows the path to the PDQ Deploy SQLite Database.

SQLite Console

Opens an SQLite console in which you can perform database management operations on the PDQ Deploy database using SQLite commands.

IMPORTANT: Use this option with care. The PDQ Deploy database is essential to PDQ Deploy operations. It stores all packages, schedules, credentials, and deployment lists. In general, it is recommended that you use this option only under the direction of Admin Arsenal support staff.

For more information on the SQL language, visit SQLite documentation at http://www.sqlite.org/lang.html.

Optimize Database

Rebuilds the database by reorganizing the data and indexes.

Over time, databases become fragmented. It is recommended that you periodically run an optimization to keep the PDQ Deploy database running at top performance. It is best practice to run this operation once per month.

NOTE: PDQ database optimization is automatically performed when the application is upgraded.

It is recommended that you run the optimization when no other programs are accessing the database. Otherwise, the other programs may time out waiting for the optimization process to complete.

IMPORTANT: Optimizing the databases stops the PDQDeploy service and closes the PDQ Deploy console. Do not optimize when there are current deployments.

 

 

 

© 2015 Admin Arsenal, Inc. All rights reserved.

Admin Arsenal is a trademark of Admin Arsenal, Inc. All other product and company names are the property of their respective owners.

Help Version: 7.0.4.0