Database Tools
Troubleshooting T-SQL Debugger Configuration Issues
T-SQL Debugger in SQL Complete and dbForge Studio for SQL Server depend on a properly configured environment and the required SQL Debugging components. If the debugger does not start, cannot connect to SQL Server, or CheckDebugger reports missing or ...
How to Collect Log Files for Code Compare
Applies to: Code Compare Log File Location The log files are sorted in the following folder: %AppData%\Roaming\Devart\Code Compare\Logs Steps to collect Logs: Reproduce the issue in Code Compare. Open File Explorer and navigate to: ...
How to Collect Log Files for dbForge SSMS Add-ins
Applies to: dbForge Search for SQL Server dbForge Index Manager for SQL Server dbForge Monitor for SQL Server dbForge Unit Test for SQL Server Log File Location The log files are stored in the following folder: %AppData%\Roaming\Devart\ Two types of ...
CPU Utilization Metric Is Empty or Shows 0 in SQL Monitor
The CPU Utilization metric in SQL Monitor is not displayed or always shows 0. The same SQL Monitor instance may work correctly for other SQL Server instances. For example, CPU utilization can be displayed normally on SQL Server 2016 while remaining ...
Transaction Notification Is Not Displayed When VIEW SERVER STATE Is Missing
The Notification if execution contains open transactions option works as expected on some SQL Server instances, but does not display any notifications on others. This behavior is typically caused by the absence of the VIEW SERVER STATE privilege for ...
Unable to Connect to AWS RDS PostgreSQL: SSL Must Be Enabled
A connection to an AWS RDS PostgreSQL instance cannot be established from dbForge Studio for PostgreSQL, while other database tools, such as PgAdmin or DBeaver, connect successfully using the same connection parameters. Cause AWS RDS PostgreSQL ...
Changing Connections Is Not Supported for Non-Empty Query Documents
Attempting to change the connection for a query document may result in the following error: "Cannot change the connection for a non-empty query document" As a result, the connection cannot be switched to another server or environment while the ...
"Object Does Not Exist" Error During Data Export from the Command Line (MySQL)
When exporting data from the command line using the /dataexport utility, the following error may occur: "Object 'database_name' does not exist" The database or object exists and can be accessed normally, but the export operation fails. This issue ...
SSH Host Key Verification Error in dbForge Studio for MySQL
Attempting to connect to a server over SSH may fail with the following error message: Can't connect to SSH server: The computed hash verification does not correspond to the received. (code 0) The same connection may work successfully in PuTTY or ...
Creating a Connection from External Parameters in dbForge Studio for MySQL
dbForge Studio for MySQL does not currently support creating or opening connections by passing connection parameters through command-line arguments or Privileged Access Management (PAM) solutions. The workaround described below allows a connection to ...
Autocomplete Cache Is Lost or Not Populated When Switching VPN or Reconnecting to a Server
Autocomplete suggestions for database objects, including tables, columns, and stored procedures, may stop appearing after switching a VPN connection or reconnecting to a SQL Server instance. In some cases, suggestions become available only after the ...
How to View Windows Logs
Windows Logs can be used to collect additional diagnostic information related to system or application issues. This article describes how to open Event Viewer and extract relevant error details. Steps Step 1. Reproduce the issue Reproduce the issue ...
Silent installation of ADD-in Tools (i.e., dbForge SQL Complete) with custom IDE selection.
dbForge SQL Complete can be installed in silent mode (without user interaction) using a configuration file (.ini). This file allows you to define in which IDEs (SSMS or Visual Studio) the integration should be performed. It also includes parameters ...
How to Activate a Trial Version in dbForge Products
Starting from release 2025.1, the method of using the trial version and Express Edition has been updated for all paid dbForge products. To help you get started smoothly, please follow the step-by-step instructions below. As of version 2025.1, ...
TLS 1.3 Support on Windows 10 with MySQL and PostgreSQL
Issue When connecting to MySQL or PostgreSQL servers on Windows 10, you may encounter errors if the server is configured to use only TLS 1.3. However, the connection succeeds if TLS 1.2 and TLS 1.3 are both enabled. Reason Windows 10 does not support ...
CPU Metrics Not Displayed in dbForge Monitor for SQL Server
Symptoms When using dbForge Monitor for SQL Server, you may observe that CPU metrics are not displayed for certain active connections. For instance, the CPU usage section might be empty or missing data, as illustrated in the example below: The ...
How to View System Information in dbForge Products
To help diagnose issues or provide system details to Devart support, you can easily access the system information in your dbForge product. Here's how: Open the dbForge product you are using (this applies to standalone tools like Studio for MySQL as ...
Troubleshooting Manual Activation issues
If you are experiencing difficulties with Manual Activation despite following the documentation in the Licensing and Activation section for your product (available at Devart Documentation), please consider the following steps to resolve the issue. ...
How to check the remaining days of your dbForge trial period
To see how many days are left in your dbForge trial period, follow these simple steps: Open your dbForge product. Go to the top menu and click Help. Select About from the dropdown menu. Using SQL Complete as an example, you can see the remaining ...
dbForge installer didn't install the expected edition
If you've purchased the Standard, Professional, or Enterprise edition of a dbForge product, but the installer didn't install the expected edition, it’s important to understand that the downloaded installation file (.exe) does not determine the ...
What is the difference between Standalone applications and Add-Ins?
dbForge offers a suite of powerful MiniTools designed to streamline database development and administration. These tools come in two primary forms: standalone applications and add-ins, each catering to distinct user needs and workflows. 1. dbForge ...
dbForge SQL Tools Missing After Installing or Updating SSMS
When launching SQL Server Management Studio (SSMS) for the first time after installing dbForge SQL Tools, a brief initialization process is expected. This typically takes 1–2 minutes depending on system performance. If the tools—such as SQL ...
Functional Differences Between Tool Versions and Studio Versions
dbForge tools are available in multiple editions, each designed to meet different user needs. Whether you’re considering the Standard, Professional, or Enterprise edition of a product like SQL Complete, it's important to understand what functionality ...
Unable to Install Product from the ".exe" File Downloaded from the Website on macOS or Linux
If you are trying to install dbForge products on your machine running macOS or Linux using a downloaded .exe file, it's important to understand that dbForge products can only be installed via CrossOver. For guidance on how to install dbForge products ...
Can a Single License Be Shared by Two Users on a Remote Machine?
According to the company's End User License Agreement (EULA) policy, each purchased license provides a key that can be used for activation on two machines simultaneously. For more details, please refer to the following link: Devart EULA. It's ...
Lost Connection to MySQL Server
A lost connection to a MySQL server is a common issue and, in most cases, is not related to dbForge tools. It typically occurs due to server settings, network interruptions, or long-running queries. Recommended Solution For official guidance on ...
Error: "Unsaved documents cannot be cut or copied to the clipboard from the miscellaneous files project" in SSMS
When attempting to copy text from the Find and Replace window in SQL Server Management Studio (SSMS), the following error message may appear: "Unsaved documents cannot be cut or copied to the clipboard from the miscellaneous files project. You must ...
How to Expedite Error Report Resolution
In addition to the standard procedure for submitting an Error Report, the following steps can significantly help us resolve the issue more quickly and efficiently. While the information provided in the original report is valuable, these additional ...
Installing the Product with Logging
If you experience problems, crashes, or errors during the installation of the product, you can perform the installation with logging enabled to capture detailed information. Steps for Installing the Product with Logging: Download the Latest Version ...
How to Start dbForge Products with Logging for Studios, Standalone Tools, and MiniTools
If a dbForge product crashes or becomes unresponsive upon startup, logging is required for a detailed record of failures and issues. This guide helps you launch dbForge products with logging enabled to capture essential information for ...
How to Enable Logging for Source Control and Data Pump for SQL Server
Logging is essential for capturing detailed information about failures and issues in the program. If reproducing or diagnosing a problem is difficult, logging helps in providing a deeper investigation. This guide applies to the following products: ...
How to Enable Logging for SSMS Add-ins Without Built-in Logging
Logging is essential for diagnosing complex issues and capturing technical details that may not be immediately visible through the user interface. When troubleshooting failures or unexpected behavior in SSMS add-ins that do not provide built-in ...
How to Enable Logging for Studios, Standalone Tools, and MiniTools
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 ...
How to Create a Dump File from Task Manager for SSMS and Integrated Add-ins
In cases where SSMS (SQL Server Management Studio) or any integrated add-ins freeze or stop responding, a dump file can be generated for debugging purposes. This applies to both SSMS and the following dbForge add-ins for SQL Server: dbForge SQL ...
How to Create a Dump File from Task Manager for Studios, Standalone Tools, and MiniTools
If you encounter issues with Studios, Standalone Tools, or MiniTools, you can generate a dump file using Task Manager for further troubleshooting. Follow these steps to create a dump file. Steps to Create a Dump File from Task Manager: Reproduce the ...
How to Automatically Create a Dump File on Crash for Studios, Standalone Tools, and MiniTools
If a crash occurs, you can configure the system to automatically create a dump file for debugging purposes. Follow the steps below to create the required registry keys for different products, such as dbForge Studio, Standalone Tools, and MiniTools. ...
How to Generate a "dump_crash" for SSMS, Including Add-in Tools
If SQL Server Management Studio (SSMS) crashes, it’s possible to configure your system to automatically generate a memory dump file. This file is essential for identifying issues related to both SSMS and integrated tools such as SQL Complete. This ...
How to Enable Logging for SQL Complete
Logging is a standard mechanism used in many software tools to capture detailed information about application behavior, errors, and performance issues. It is particularly useful when diagnosing problems that are difficult to reproduce or analyze in ...
Data Compare for Oracle – BINARY_DOUBLE Type Support
When using dbForge Data Compare for Oracle, it's important to understand limitations related to specific Oracle data types, especially when operating in Direct mode. Some Oracle data types are not fully supported in this mode, including: ...
Timestamps Not in Expected Timezone in dbForge Studio for Oracle
If you're encountering timestamps that don't match your system's timezone in dbForge Studio for Oracle, this can typically be resolved with a quick configuration update. This issue may arise due to default formatting settings or discrepancies in how ...
Next page
In Claude, just add the Devart Learn connector; in other AI tools, copy this URL and paste it as a new MCP under the Integrations or Connectors tab: https://chatbot.devart.com/api/mcp