How to Run DB Upgrade & Utility

When to Use These Tools

You should run DBUtility or DBUpgrade if:

• Webgility Desktop is returning database-related errors.

• The database size has grown significantly.

• Webgility Desktop performance is slow or unresponsive.

 Run UnifyDBUtility – Step-by-Step Guide

This utility optimizes and compresses your database for better performance.

 Location:  C:\Webgility \UnifyEnterprise\UnifyDBUtility.exe

 Steps:

1. Close Webgility Desktop Software and Scheduler

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

   • Open Task Manager and end any Webgility Desktop-related processes still running.
     
     

2. Navigate to the Utility File

   • Go to the primary computer where the Webgility Desktop database is installed.

   • Open the C:\Webgility\UnifyEnterprise folder.

   • Locate and run the file named UnifyDBUtility.exe.
     
     

3. Follow On-Screen Prompts

   • You’ll be asked to confirm if you want to execute the utility.

   • Make sure no Webgility Desktop or Scheduler instances are running. Click OK.
     
     

4. Create a Backup

   • The tool will prompt you to back up the database.

   • Click OK and choose a valid location (we recommend using the Webgility Desktop folder itself).
     
     

5. Wait for Optimization to Complete

   • Once the backup is done, the optimization will begin.

   • Do not restart or turn off your computer during this process.
     
     

6. Finish & Reopen Webgility Desktop

   • Once you see the “Success” confirmation, you may close the utility.

   • Reopen Webgility Desktop and verify that the issue has been resolved.

 Run UnifyDBUpgrade – Step-by-Step Guide

This tool is used for database reindexing and to upgrade the structure when errors are encountered or prompted by Webgility Desktop.

  Location: C:\Webgility \UnifyEnterprise\UnifyDBUpgrade.exe

  Steps:

1. Close Webgility Desktop Software and Scheduler

   • Make sure all Webgility Desktop applications and Scheduler services are closed across all computers.

   • End any remaining processes using Task Manager.
     
     

2. Access the Upgrade Tool

   • On the main computer where your Webgility Desktop database is located, go to:
     C:\Webgility\UnifyEnterprise

   • Find and run UnifyDBUpgrade.exe.
     
     

1. Wait for Confirmation

   • The tool will run a series of upgrade steps.

   • Once complete, a “Success” message will appear.
     
     

2. Log Back into Webgility Desktop

   • Close the tool, reopen Webgility Desktop, and ensure the issue is resolved or performance is improved.