dbForge Schema Compare for SQL Server is available as part of a bundle. You can install it 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 Schema Compare on Linux & macOS.
When Schema Compare 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\Compare Bundle for SQL Server\dbForge Schema Compare 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 Schema Compare as a part of dbForge SQL Tools for SQL Server, it will be located in the C:\Program Files\Devart\dbForge SQL Tools directory.
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 comparebundlesqlpro.exe to begin installation.
3. On the Welcome to the Compare Bundle for SQL Server page, click Install.
4. On the Select Destination page, select the directory where dbForge Schema Compare for SQL Server will be installed. To change the default directory, click Browse. To restore the default directory, click Restore default location. Optionally, click the License Terms link to learn the End-User Agreement for dbForge Schema Compare for SQL Server. If you agree to the Devart dbForge Schema Compare for SQL Server License Terms, click Next.
5. On the Select Products page, select the tool to install and click Next.
6. Click Finish to exit Setup wizard.
Note
The Schema Compare SSMS add-in comes bundled with the standalone Schema Compare application. Both are installed simultaneously with the dbForge Compare Bundle or dbForge SQL Tools products. Upon installation, the Schema Compare add-in automatically integrates with SQL Server Management Studio (SSMS). Notice that it may take a few minutes for all options to appear in the SSMS interface including context menus.
You can download and install dbForge Schema Compare for SQL Server 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 Schema Compare:
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 Schema Compare for SQL Server. For this, enter the following command in the PowerShell window and press Enter:
choco install dbforge-sql-schcmpr
Note
dbForge Schema Compare for SQL Server can be also downloaded and installed as part of the dbForge Compare Bundle for SQL Server, which also includes the dbForge Data Compare tool. To download and install Compare Bundle, run
choco install dbforge-sql-cb
4. Agree to run the script by pressing Y or A.
5. Wait for installation to complete. Chocolatey will download the dbForge Schema Compare 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-schcmpr or dbforge-sql-cb 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.
For your convenience, we have created a short step-by video to help you with the dbForge Schema Compare istallation: