Logging is essential for capturing detailed information about failures and issues within the software. If reproducing or diagnosing a problem is difficult, or if deeper investigation is needed, logging can help gather more information for troubleshooting. 

Applicable Products:

Studios:

• dbForge Studio for SQL Server
• dbForge Studio for MySQL
• dbForge Studio for Oracle
• dbForge Studio for PostgreSQL

Standalone Tools:

• dbForge Data Compare for SQL Server
• dbForge Schema Compare for SQL Server
• dbForge Data Generator for SQL Server
• dbForge Query Builder for SQL Server
• dbForge Documenter for SQL Server
• dbForge Event Profiler for SQL Server
• dbForge Transaction Log

MiniTools:

• dbForge Schema Compare for MySQL

• dbForge Data Compare for MySQL

• dbForge Data Generator for MySQL

• dbForge Documenter for MySQL

• dbForge Query Builder for MySQL

• dbForge Schema Compare for Oracle

• dbForge Data Compare for Oracle

• dbForge Data Generator for Oracle

• dbForge Documenter for Oracle

• dbForge Schema Compare for PostgreSQL

• dbForge Data Compare for PostgreSQL

Steps to Enable Logging:

1. Open the Options Window:

   • In the main menu, select Tools -> Options.... This will open the Options window.

2. Navigate to the Logging Options:

   • In the Options window, go to Environment -> Output.

3. Enable Logging:

   • Select the following options:
     • Write queries sent by the program to the SQL Log.
     • Log application errors.

4. Preserve Logs:

   • Uncheck the option Delete application log after closing.

5. Reproduce the Issue:

   • After enabling logging, reproduce the issue you are experiencing.

6. Locate the Log File:

   • Once the issue has been reproduced, send the latest .log file from the following folder:
     • %SystemDrive%\Users\%UserName%\AppData\Roaming\Devart\current_product\
     • Example: %SystemDrive%\Users\%UserName%\AppData\Roaming\Devart\dbForge Studio for MySQL\


Note: Once you’ve successfully completed logging, it’s recommended to disable it to prevent excessive disk space usage. To do this, open Options → Environment → Output, then uncheck the following options:

1. Write queries sent by the program to the SQL Log
2. Log application errors

Also, make sure to enable the Delete application log after closing option.