How to install dbForge Search
dbForge Search for SQL Server allows SQL Server developers and administrators to search for specific objects and data within their SQL Server databases quickly and easily. The tool provides advanced search capabilities, including fuzzy search, wildcard search, regular expression search, and the ability to search across multiple databases simultaneously.
The topic describes how to install dbForge Search.
Install dbForge Search using the installation wizard
Note
During the search process, dbForge Search does not alter the structure of tables or modify the data stored in them.
To install dbForge Search, you will need to do two things: download the installation file from the Devart website and run it on your machine.
Download the installation file
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.
To download the installation file, go to the Devart website.
Install dbForge Search on your computer
1. Once you open the installer, you will see the Start Page of the wizard. Click Install to proceed.
2. Choose the directory to install dbForge Search. Then, click Next.
3. Click Next.
4. Now, you will see three startup optimization options. Read the brief descriptions that are available in the installer and choose the option that is the most appropriate in your particular case. Click Next, once done.
5. Finally, the installation process begins. The wizard will extract the files and perform the application startup optimization. Allow it a couple of minutes to finish.
6. You will be notified about the installation completion. To launch dbForge Search right away, make sure to select the corresponding checkbox. Then, click Finish to close the wizard.
7. After the installation, dbForge Search appears on the MS SSMS context menu bar.
Install dbForge Search using Chocolatey
You can download and install dbForge Search 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 Search:
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 dbForge Search. For this, enter the following command in the PowerShell window and press Enter:
choco install dbforge-sql-search
Note
dbForge Search 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 Search 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-search 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.