Installation

SQL Complete is an add-in for SSMS and Microsoft Visual Studio, which delivers advanced IntelliSense-style SQL code autocompletion, smart code formatting, and refactoring. Additionally, it offers a T-SQL debugger and a number of productivity-enhancing features to boot.

To install this Devart product, you will need to do two things: download the installation file from our website and run it on your personal machine.

Download SQL Complete

To download the product, visit the Devart website. SQL Complete is available in Standard and Professional editions, as well as in a fully functioning trial version.

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.

Install SQL Complete using the installation wizard

1. Once you open the installer, you will see the Start Page of the wizard. Click Install to proceed.

SQL Complete Installation

2. Choose the directory to install the SQL Complete. Then, click Next.

SQL Complete Installation

3. In this step, you will be able to select the products you would like to integrate SQL Complete into: SQL Server Management Studio or/and Visual Studio. Click Next.

SQL Complete Installation

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.

SQL Complete Installation

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.

SQL Complete Installation

6. You will be notified about the installation completion. To launch SQL Complete right away, make sure to put a tick into the corresponding checkbox. Then, click Finish to close the wizard.

SQL Complete Installation

7. After the installation, the SQL Complete menu appears on the MS SSMS and/or VS menu bar. Note that it may take a few minutes for all options to appear in the SSMS interface including context menus.

SQL Complete InstallationSQL Complete Installation

Now SQL Complete should be enabled by default. If you see Disable Code Completion in the menu, the add-in is all set. In case you will need to turn it on after disabling in the future, click Enable Code Completion.

Install SQL Complete from the command line

dbForge tools can be installed from the command line with or without the interaction with the end user.

If you run the installer file from the command line, the standard Installation wizard will be displayed, where you can select the installation configurations. For this, open the Command Prompt and navigate to the installation file. For example:

C:\Downloads>sqlcomplete.exe

Note

The actual name of the installer file may vary according to the product version.

You can run the installer with the /silent or /verysilent option. For example:

sqlcomplete.exe /silent

-or-

sqlcomplete.exe /verysilent
  • Silent Mode: In this mode, the installation runs in the background. You can see the installation progress, but no intervention is required.

  • Very Silent Mode: In this mode, the installation runs entirely in the background with no visible windows or user interaction.

Install SQL Complete using Chocolatey

You can download and install dbForge SQL Complete 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 SQL Complete:

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

choco install dbforge-sql-cmpl

Note

dbForge SQL Complete 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 SQL Complete using Chocolatey

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

Install dbForge SQL Complete 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 SQL Complete 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:\sqlcomplete.exe" -ArgumentList "/verysilent" -Wait

The features of SQL Complete

To get a closer look at the key features of SQL Complete, refer to our Documentation:

Want to Find out More?

Overview

Overview

Take a quick tour to learn all about the key benefits delivered by dbForge SQL Complete for SQL Server.
All Features

All features

Get acquainted with the rich features and capabilities of the SQL Complete in less than 5 minutes.
Request a demo

Request a demo

If you consider employing the SQL Complete for your business, request a demo to see it in action.
Ready to start using dbForge SQL Complete for SQL Server?