How to use the Database Analyzer and Database Fixer Utilities

How to use the Database Analyzer and Database Fixer Utilities

QUESTIONS THAT APPLY TO THIS TOPIC

  • How do I use the database analyzer?
  • How do I use the database fixer?

 

ANSWER

            Database Analyzer 
  1. Make sure that everyone has closed Gorilla.
  2. Make a backup of your database.
  3. Click on the start menu, select Programs, BGM – Gorilla CRM® System for Financial Services, and choose Database Analyzer.

  4. The Default and Playground buttons to the right of the directory lines toggle between which directories you want to run the analyzer on.  If you are running the analyzer on your regular database, that is selected by default.  To run the analyzer on your Playground, simply click the Playground button.  Click Next to continue.
  5. The database analyzer will then proceed through its process, and display the results.  You have the option to save and to print from this screen, as well.  Click finish, and the Database Analyzer will close.

Database Fixer

  1. Make sure that everyone has closed out of Gorilla.
  2. If you haven’t done so already, make a backup of your database.
  3. Click on the start menu, select Programs, BGM – Gorilla CRM System for Financial Services, and choose Database Fixer.

  4. The Fix Gorilla Database and Fix Playground Database below the directory lines toggle between which directories you want to fix.  If you are running the analyzer on your regular database, that is selected by default.  To run the analyzer on your Playground, simply click the Fix Playground Database button.  The Add Sample Contact Groups checkbox will add several contact groups to the database.  They are good for testing purposes.  Click Next to continue.
  5. Click Finish and the database fixer will then proceed through its process, and display the results.  You have the option to save and to print from this screen, as well.  Click close, and the Database Fixer will close.