How to install dbForge Unit Test

This topic describes how to install dbForge Unit Test for SQL Server on Windows OS.

Install dbForge Unit Test for SQL Server using the installation wizard

Note

Before starting the installation process, make sure all the running instances of the product and SSMS are closed.

  1. Download the product from the Devart website.
  2. Run the installer and follow the instructions.

The product is listed on the Start menu under Devart.

After installation, the Unit Test menu appears on the MS SSMS menu bar. Be aware that it may take a few minutes for all new options to appear in the SSMS interface.

Launch the installation of the SQL Server unit testing framework Unit Test from the Unit Test main menu

Install dbForge Unit Test using Chocolatey

You can download and install dbForge Unit Test 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 Unit Test:

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 Unit Test. For this, enter the following command in the PowerShell window and press Enter:

choco install dbforge-sql-ut

Note

dbForge Unit Test for SQL Server 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.

Install dbForge Unit Test using Chocolatey

5. Wait for installation to complete. Chocolatey will download the dbForge Unit Test for SQL Server 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-ut or dbforge-sql-tools in this list, depending which product you chose to install.

Install dbForge Unit Test using Chocolatey

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.

Install dbForge Unit Test using PowerShell

To install the tool via PowerShell, use the following command:

Start-Process -FilePath $installerPath -ArgumentList $arguments -Wait

  • $installerPath is a variable containing the path to the installer file

  • $arguments is a variable containing command line arguments for installing in silent mode

  • Start-Process is the PowerShell command to start a process that includes the installer path and command line arguments

  • Wait is the command to wait for the installation to complete

Optionally, you can include the /verysilent parameter to perform the installation without displaying any messages and without any user’s intervention.

For example, the PowerShell command could look like this:

Start-Process -FilePath "D:\sqltoolspro.exe" -ArgumentList "/verysilent" -Wait