Skip to content
  • There are no suggestions because the search field is empty.

How to Run Database Utility and Upgrade Tools for Webgility Desktop

This article helps Webgility Desktop users in addressing performance issues or errors related to the Webgility Desktop database.

If you're experiencing performance issues or errors related to the Webgility database, running the DBUtility or DBUpgrade tools can help resolve those problems. These tools are designed to optimize, shrink, and repair your Webgility database when it becomes too large or corrupted.


Here is your step-by-step guide to running these utilities safely and effectively.

When to Use These Tools

  • Webgility is running slowly or crashing

  • Database size has grown significantly

  • You receive a database-related error

  • Webgility Support advises running these tools

🔧 How to Run UnifyDBUtility

This tool is used to optimize and shrink the Webgility database to improve performance.

Steps:

1. Close All Webgility Sessions

  • Ensure Webgility Desktop and the Scheduler are closed on all machines.

  • Open Task Manager and end any remaining Webgility processes.

2. Locate the Utility File

  • On the primary machine where Webgility is installed, go to:
    C:\Webgility\UnifyEnterprise

  • Find and double-click the file named UnifyDBUtility.

3. Initiate the Utility

  • A prompt will appear asking if you want to execute DBUtility.

  • Click OK to proceed.

  • You’ll be asked to close all Webgility applications—click OK again.

4. Create a Backup

  • You will be prompted to back up your database before proceeding.

  • Choose a valid folder (preferably the Webgility folder itself) to save the backup.

  • Click OK to begin the backup.

5. Allow the Optimization to Complete

  • Do not close the window or restart your computer while the process runs.

  • Wait until you see the Success pop-up message.

6. Finish and Verify

  • Click OK to close the utility.

  • Reopen Webgility and check if performance or error issues have been resolved.

🔄 How to Run UnifyDBUpgrade

This tool performs a database reindex and upgrade, useful when directed by Support or when encountering specific database errors.

Steps:

1. Close All Webgility Sessions

  • Shut down Webgility and the Scheduler on all machines.

  • Use Task Manager to ensure no Webgility processes are still running.

2. Locate the Upgrade Tool

  • On the main machine, navigate to:
    C:\Webgility\UnifyEnterprise

  • Find and double-click the file named UnifyDBUpgrade.

3. Run the Upgrade

  • The process runs automatically. Wait until you see the Success notification.

  • Once done, close the window.

4. Log Back In

  • Open Webgility Desktop and verify that the application is functioning as expected.

Notes:

  • Always back up your database before running any utilities.

  • These tools should only be run on the primary Webgility machine.

  • Do not interrupt the process once it begins.