Most Devart tools for SQL Server are available as part of a bundle. You can select which individual products to install when you run the installer. dbForge tools can be installed using the installation wizard or from the command line. To learn how to install the tool on Linux or macOS, refer to How to Install dbForge Query Builder on Linux & macOS.
When Query Builder is installed on your computer, it includes executables, associated libraries, and configuration files necessary to provide its functionality.
By default, it is installed in the C:\Program Files\Devart\dbForge Query Builder for SQL Server directory on your Windows system. However, during the installation process, you have the option to change the destination directory by selecting a different folder where you want to install the application.
Note
If you got Query Builder as a part of dbForge SQL Tools for SQL Server, it will be located in the C:\Program Files\Devart\dbForge SQL Tools directory.
The topic describes how to install dbForge Query Builder for SQL Server.
1. Download the tool from the Devart website.
2. Run qbuildersql.exe to launch the installation.
3. In the dbForge Query Builder for SQL Server wizard that opens, click Install:
4. On the Select Destination page, click Browse to set the directory where dbForge Query Builder will be installed and then click Next:
Note
If you want to restore the default location of the folder in which dbForge Query Builder will be installed, click Restore default location.
To create a desktop shortcut, select the Create a desktop shortcut checkbox.
To read the end-user agreement for dbForge Query Builder for SQL Server, click the License Agreement link.
5. On the File Associations page, select the file extensions to be used with dbForge Query Builder and click Next:
6. On the Startup Optimization page, select the option that can improve the performance and click Next:
After the installation is complete, click Finish to close the setup wizard. This will launch dbForge Query Builder for SQL Server.
If you want to start the tool later, clear the Launch dbForge Query Builder for SQL Server checkbox and click Finish.
You can download and install dbForge Query Builder using Chocolatey, which is a package manager for Windows. Before you start, ensure you have Chocolatey installed on your machine. If not, you can download it from the official website.
Once you have Chocolatey installed, you can follow these steps to install dbForge Query Builder:
1. Open PowerShell as Administrator. For this, right-click the Windows PowerShell app, and select Run as administrator.
2. Ensure that the Get-ExecutionPolicy is not restricted. For this, run
Get-ExecutionPolicy
If it returns Restricted, then run
Set-ExecutionPolicy AllSigned
or
Set-ExecutionPolicy Bypass -Scope Process
This will allow PowerShell to run scripts for the current session.
3. Initiate the installation of Query Builder. For this, enter the following command in the PowerShell window and press Enter:
choco install dbforge-sql-qb
Note
dbForge Query Builder can be also downloaded and installed as part of the dbForge SQL Tools bundle, which includes 15 tools that extend Microsoft SSMS with multiple essential features. To download and install dbForge SQL Tools, run
choco install dbforge-sql-tools
4. Agree to run the script by pressing Y or A.
5. Wait for installation to complete. Chocolatey will download the dbForge Query Builder package and install it on your computer.
6. Confirm the installation. Once the installation is complete, you can confirm it by running:
choco list --local-only
This command will list all the packages installed on your computer through Chocolatey. If the installation was successful, you should see dbforge-sql-qb or dbforge-sql-tools in this list, depending which product you chose to install.
Using Chocolatey, you can download and install all dbForge SQL tools at once. For more information, refer to How to Install 15 dbForge SQL Tools in 15 Minutes Using Chocolatey article.