For the best web experience, please use IE11+, Chrome, Firefox, or Safari

System requirements

Find out what OS’s, SQL Server versions, SSMS and VS editions, and Source Control systems are supported by ApexSQL tools here.

ApexSQL Analyze

Hardware

Dual Core 2.0 GHz CPU

4GB memory

125 MB disk space [6]

SQL Server

SQL Server 2005 and higher [1]

Azure SQL Database [1]

Amazon RDS for SQL Server [1]

Add-in integration

SQL Server Management Studio 2012 and higher [1][2]

Visual Studio 2010 and higher [1]

OS

Windows 7 SP1/Windows Server 2008 R2 SP1 and higher [1]

Software

ApexSQL Audit

Hardware

Dual Core 2.0 GHz CPU

4GB memory

125 MB disk space [6]

Port

TCP port 64561 and 60408 on all SQL Server instances (configurable)

Built-in reporting API:

TCP port 49152 on central ApexSQL Audit instance (configurable)

SQL Server

SQL Server 2005 and higher [1]

OS

Windows 7 SP1/Windows Server 2008 R2 SP1 and higher [1]

Software

.NET Framework 4.7.2 or higher

SQL Server 2008 or higher [1], for the Central repository database

Note

SQL Server Express edition is not recommended for the Central repository database, due to the database size limitation

Permissions and additional requirements

Windows user account with administrative privileges

Central repository database must be located on the central ApexSQL Audit instance

See ApexSQL Audit - Permissions and requirements

Built-in reporting API:

Windows user account with ApexSQL Audit access

Trusted SSL certificate

See: Using API to generate SQL auditing reports

ApexSQL Build

Hardware

Dual Core 2.0 GHz CPU

3 GB memory

160 MB disk space

SQL Server

SQL Server 2005 and higher [1]

Azure SQL Database [1]

Amazon RDS for SQL Server [1]

OS

Windows 7 SP1/Windows Server 2008 R2 SP1 and higher [1]

Software

Note

Source control integration available for Azure DevOps [4], Git [5], Mercurial [5], Subversion [5] and Perforce [5]

ApexSQL Compare

Hardware

Dual Core 2.0 GHz CPU

2 GB memory

113 MB disk space

SQL Server

SQL Server 2005 and higher [1]

Azure SQL Database [1]

Amazon RDS for SQL Server [1]

Add-in integration

SQL Server Management Studio 2012 and higher [1][2]

Visual Studio 2010 and higher [1]

OS

Windows 7 SP1/Windows Server 2008 R2 SP1 and higher [1]

Software

Permissions and additional requirements

ApexSQL Complete

Hardware

Dual Core 2.0 GHz CPU

4 GB memory

139 MB disk space [6]

SQL Server

SQL Server 2005 and higher [1]

Azure SQL Database [1]

Amazon RDS for SQL Server [1]

Add-in integration

SQL Server Management Studio 2012 and higher [1][2]

Visual Studio 2010 and higher [1]

OS

Windows 7 SP1/Windows Server 2008 R2 SP1 and higher [1]

Software

Permissions and additional requirements

ApexSQL Data Diff

Hardware

Dual Core 2.0 GHz CPU

3 GB memory

209 MB disk space

SQL Server

SQL Server 2005 and higher [1]

Azure SQL Database [1]

Amazon RDS for SQL Server [1]

Add-in integration

SQL Server Management Studio 2012 and higher [1][2]

Visual Studio 2010 and higher [1]

OS

Windows 7 SP1/Windows Server 2008 R2 SP1 and higher [1]

Software

Note

Source control integration available for Azure DevOps [4], Git [5], Mercurial [5], Subversion [5] and Perforce [5]

Permissions and additional requirements

ApexSQL Data Diff for MySQL

Hardware

Dual Core 2.0 GHz CPU

3 GB memory

156 MB disk space [6]

MySQL Server

MySQL Server 5.6 and higher [1]

MariaDB Server 10.1 and higher [1]

Azure Database for MySQL [1]

Azure Database for MariaDB [1]

Amazon RDS for MySQL [1]

Amazon RDS for MariaDB [1]

OS

Windows 7 SP1/Windows Server 2008 R2 SP1 and higher [1]

Software

Permissions and additional requirements

Windows user account with administrative privileges

See Minimum permissions required to install and use ApexSQL products

ApexSQL Database Power Tools for VS Code

Hardware

Dual Core 1.6 GHz CPU

1 GB memory

279 MB disk space

Server

MySQL Server 5.6 and higher [1]

MariaDB Server 10.1 and higher [1]

Azure Database for MySQL [1]

Azure Database for MariaDB [1]

Amazon RDS for MySQL [1]

Amazon RDS for MariaDB [1]

Amazon Aurora for MySQL [1]

Add-in integration

Visual Studio Code 1.52 and higher [1]

OS

Windows 7 and higher [1]

OS X Yosemite (10.10) and higher [1]

Ubuntu Desktop 14.04 and higher [1]

Debian 7 and higher [1]

CentOS 7 and higher [1]

Fedora 23 and higher [1]

ApexSQL Decrypt

Hardware

Dual Core 2.0 GHz CPU

3 GB memory

98 MB disk space

SQL Server

SQL Server 2005 and higher [1]

Add-in integration

SQL Server Management Studio 2012 and higher [1] [2]

Visual Studio 2010 and higher [1]

OS

Windows 7 SP1/Windows Server 2008 R2 SP1 and higher [1]

Software

Permissions and additional requirements

ApexSQL Defrag

Hardware

Dual Core 2.0 GHz CPU

3 GB memory

133 MB disk space [6]

SQL Server

SQL Server 2005 and higher [1]

OS

Windows 7 SP1/Windows Server 2008 R2 SP1 and higher [1]

Software

.NET Framework 4.7.2 or higher

SQL Server 2008 or higher [1], for the Central repository database

Note

SQL Server Express edition is not recommended for the Central repository database, due to the database size limitation

Permissions and additional requirements

Windows user account with administrative privileges

sysadmin SQL Server role

See Minimum permissions required to install and use ApexSQL products

ApexSQL DevOps toolkit

Hardware

Dual Core 2.0 GHz CPU

4 GB memory

SQL Server

SQL Server 2005 and higher [1]

OS

Windows 7 SP1/Windows Server 2008 R2 SP1 and higher [1]

Software

.NET Framework 4.7.2 or higher

ApexSQL Build 2020 R3 [3]

ApexSQL Data Diff 2019 R3 [3]

ApexSQL Diff 2021 [3]

ApexSQL Doc 2019 [3]

ApexSQL Enforce 2019 R2 [3]

ApexSQL Generate 2020 R3 [3]

ApexSQL Mask 2020 R2 [3]

ApexSQL Refactor 2020 R4 [3]

ApexSQL Script 2020 R2 [3]

ApexSQL Unit Test 2019 R2 [3]

Note

The number of ApexSQL tools required is based on how extensive a CI/CD workflow pipeline is and how many steps it includes

Source control integration available for Azure DevOps [4], Git [5], Mercurial [5], Subversion [5] and Perforce [5]

Azure DevOps Server (TFS) / Azure DevOps Services plug-in

Hardware: 5.5 MB disk space

Software: TFS 2015 Update 2 or higher, Azure DevOps Services

Bamboo plug-in

Hardware: 5.4 MB disk space

Software: Atlassian Bamboo 6.6.3 or higher

Jenkins plug-in

Hardware: 5.8 MB disk space

Software:  Jenkins 2.138 or higher

Octopus Deploy step templates

Hardware: 32 KB disk space

Software: Octopus v2018.9.11 or higher

PowerShell scripts

Hardware: 550 KB disk space

Software: PowerShell 5.0, NuGet 3.5.0 or higher

TeamCity plug-in

Hardware: 16.8 MB disk space

Software: TeamCity 10.0 or higher

Web dashboard

Hardware: 341MB disk space [6]

Software: Internet Explorer 11 or higher, Edge build 14393 or higher, Chrome 50 or higher, Mozilla Firefox 50 or higher, Opera 40 or higher

Port: TCP port 5019 (http) and 4443 (https) on ApexSQL DevOps toolkit - Web Dashboard web server (configurable)

ApexSQL Diff

Hardware

Dual Core 2.0 GHz CPU

3 GB memory

219 MB disk space

SQL Server

SQL Server 2005 and higher [1]

Azure SQL Database [1]

Amazon RDS for SQL Server [1]

Add-in integration

SQL Server Management Studio 2012 and higher [1] [2]

Visual Studio 2010 and higher [1]

OS

Windows 7 SP1/Windows Server 2008 R2 SP1 and higher [1]

Software

Note

Source control integration available for Azure DevOps [4], Git [5], Mercurial [5], Subversion [5] and Perforce [5]

Permissions and additional requirements

ApexSQL Diff for MySQL

Hardware

Dual Core 2.0 GHz CPU

3 GB memory

155 MB disk space [6]

MySQL Server

MySQL Server 5.6 and higher [1]

MariaDB Server 10.1 and higher [1]

Azure Database for MySQL [1]

Azure Database for MariaDB [1]

Amazon RDS for MySQL [1]

Amazon RDS for MariaDB [1]

OS

Windows 7 SP1/Windows Server 2008 R2 SP1 and higher [1]

Software

Permissions and additional requirements

Windows user account with administrative privileges

See Minimum permissions required to install and use ApexSQL products

ApexSQL Doc

Hardware

Dual Core 2.0 GHz CPU

4 GB memory (RAM memory requirements may increase when documenting large quantities of SSIS packages, databases, etc.)

169 MB disk space [6]

SQL Server

SQL Server 2005 and higher [1]

Azure SQL Database [1]

Amazon RDS for SQL Server [1]

SharePoint

SharePoint Server 2013 and higher

Tableau

Tableau Online

Tableau Server 9 and higher

Add-in integration

SQL Server Management Studio 2012 and higher [1] [2]

Visual Studio 2010 and higher [1]

OS

Windows 7 SP1/Windows Server 2008 R2 SP1 and higher [1]

Permissions and additional requirements

Windows user account with administrative privileges

See ApexSQL Doc – Permissions and requirements

See Remote access for SQL Server instance

ApexSQL Doc for MySQL

Hardware

Dual Core 2.0 GHz CPU

4 GB memory

149 MB disk space [6]

MySQL Server

MySQL Server 8.0 and higher [1]

OS

Windows 7 SP1/Windows Server 2008 R2 SP1 and higher [1]

Permissions and additional requirements

Windows user account with administrative privileges

See Minimum permissions required to install and use ApexSQL products

ApexSQL Enforce

Hardware

Dual Core 2.0 GHz CPU

3 GB memory

139 MB disk space

SQL Server

SQL Server 2005 and higher [1]

Azure SQL Database [1]

Amazon RDS for SQL Server [1]

Add-in integration

SQL Server Management Studio 2012 and higher [1] [2]

Visual Studio 2010 and higher [1]

OS

Windows 7 SP1/Windows Server 2008 R2 SP1 and higher [1]

Software

Permissions and additional requirements

ApexSQL Generate

Hardware

Dual Core 2.0 GHz CPU

3 GB memory

199 MB disk space [6]

SQL Server

SQL Server 2005 and higher [1]

Azure SQL Database [1]

Amazon RDS for SQL Server [1]

Add-in integration

SQL Server Management Studio 2012 and higher [1] [2]

OS

Windows 7 SP1/Windows Server 2008 R2 SP1 and higher [1]

Software

Permissions and additional requirements

ApexSQL Job

Hardware

Dual Core 2.0 GHz CPU

3 GB memory

136 MB disk space [6]

SQL Server

SQL Server 2005 and higher [1]

OS

Windows 7 SP1/Windows Server 2008 R2 SP1 and higher [1]

Software

Permissions and additional requirements

Windows user account with administrative privileges

sysadmin SQL Server role

See Minimum permissions required to install and use ApexSQL products

ApexSQL Log

Hardware

Dual Core 2.0 GHz CPU

4 GB memory

500 MB disk space

SQL Server

SQL Server 2005 and higher [1]

OS

Windows 7 SP1/Windows Server 2008 R2 SP1 and higher [1]

Port

TCP ports 60408 and 65100 on all SQL Server instances and on ApexSQL Log installed machine

Software

Note

Databases secured with Transparent Data Encryption (TDE) cannot be used as a source for auditing/recovery

Permissions and additional requirements

Windows user account with administrative privileges

See ApexSQL Log - Permissions and requirements

ApexSQL Manage

Hardware

Dual Core 2.0 GHz CPU

4 GB memory

305 MB disk space [6]

SQL Server

SQL Server 2005 and higher [1]

OS

Windows 7 SP1/Windows Server 2008 R2 SP1 and higher [1]

Port

TCP ports 8285, 8286, 8288 on all SQL Server instances

Software

.NET Framework 4.7.2 or higher

SQL Server 2008 or higher [1], for the Central repository database

Note

SQL Server Express edition is not recommended for the Central repository database, due to the database size limitation

Permissions and additional requirements

Windows user account with administrative privileges

sysadmin SQL Server role

See ApexSQL Manage – Permissions and requirements

See Remote access for SQL Server instance

ApexSQL Mask

Hardware

Dual Core 2.0 GHz CPU

3 GB memory

165 MB disk space [6]

SQL Server

SQL Server 2005 and higher [1]

Azure SQL Database [1]

Amazon RDS for SQL Server [1]

OS

Windows 7 SP1/Windows Server 2008 R2 SP1 and higher [1]

Software

Permissions and additional requirements

ApexSQL Plan

Hardware

Dual Core 2.0 GHz CPU

4 GB memory

193 MB disk space

SQL Server

SQL Server 2005 and higher [1]

Azure SQL Database [1]

Amazon RDS for SQL Server [1]

Add-in integration

SQL Server Management Studio 2012 and higher [2]

Visual Studio 2010 and higher [1]

OS

Windows 7 SP1/Windows Server 2008 R2 SP1 and higher [1]

Software

Permissions and additional requirements

ApexSQL Propagate

Hardware

Dual Core 2.0 GHz CPU

3 GB memory

144 MB disk space [6]

SQL Server

SQL Server 2005 and higher [1]

Azure SQL Database [1]

Amazon RDS for SQL Server [1]

OS

Windows 7 SP1/Windows Server 2008 R2 SP1 and higher [1]

Software

Permissions and additional requirements

ApexSQL Pump

Hardware

Dual Core 2.0 GHz CPU

3 GB memory

176 MB disk space [6]

SQL Server

SQL Server 2005 and higher [1]

Azure SQL Database [1]

Amazon RDS for SQL Server [1]

OS

Windows 7 SP1/Windows Server 2008 R2 SP1 and higher [1]

Software

Permissions and additional requirements

ApexSQL Recover

Hardware

Dual Core 2.0 GHz CPU

4 GB memory

500 MB disk space

SQL Server

SQL Server 2005 and higher [1]

OS

Windows 7 SP1/Windows Server 2008 R2 SP1 and higher [1]

Port

TCP ports 60408 and 65100 on all SQL Server instances and on ApexSQL Recover installed machine

Software

Note

Databases secured with Transparent Data Encryption (TDE) cannot be used as a source for auditing/recovery

Permissions and additional requirements

Windows user account with administrative privileges

See ApexSQL Recover - Permissions and requirements

ApexSQL Refactor

Hardware

Dual Core 2.0 GHz CPU

4 GB memory

131 MB disk space [6]

SQL Server

SQL Server 2005 and higher [1]

Azure SQL Database [1]

Amazon RDS for SQL Server [1]

Add-in integration

SQL Server Management Studio 2012 and higher [1][2]

Visual Studio 2010 and higher [1]

OS

Windows 7 SP1/Windows Server 2008 R2 SP1 or higher [1]

Software

Permissions and additional requirements

ApexSQL Script

Hardware

Dual Core 2.0 GHz CPU

3 GB memory

181 MB disk space [6]

SQL Server

SQL Server 2005 and higher [1]

Azure SQL Database [1]

Amazon RDS for SQL Server [1]

OS

Windows 7 SP1/Windows Server 2008 R2 SP1 and higher [1]

Software

Note

Source control integration available for Azure DevOps [4], Git [5], Mercurial [5], Subversion [5] and Perforce [5]

Permissions and additional requirements

ApexSQL Search

Hardware

Dual Core 2.0 GHz CPU

4 GB memory

132 MB disk space [6]

SQL Server

SQL Server 2005 and higher [1]

Azure SQL Database [1]

Amazon RDS for SQL Server [1]

Add-in integration

SQL Server Management Studio 2012 and higher [1][2]

Visual Studio 2010 and higher [1]

OS

Windows 7 SP1/Windows Server 2008 R2 SP1 and higher [1]

Software

Permissions and additional requirements

ApexSQL Source Control

Hardware

Dual Core 2.0 GHz CPU

4 GB memory

263 MB disk space [6] (depends on the number of linked databases)

SQL Server

SQL Server 2005 and higher [1]

Azure SQL Database [1]

Amazon RDS for SQL Server [1]

Add-in integration

SQL Server Management Studio 2012 and higher [1] [2]

OS

Windows 7 SP1/Windows Server 2008 R2 SP1 or higher [1]

Software

Note

Source control integration available for Azure DevOps [4], Git [5], Mercurial [5], Subversion [5] and Perforce [5]

ApexSQL Unit Test

Hardware

Dual Core 2.0 GHz CPU

4 GB memory

192 MB disk space

SQL Server

SQL Server 2005 and higher [1]

Azure SQL Database [1]

Add-in integration

SQL Server Management Studio 2012 and higher [1] [2]

OS

Windows 7 SP1/Windows Server 2008 R2 SP1 or higher [1]

Software

Note

The most recent version of tSQLt can be found on this link

Permissions and additional requirements

[1] See Supported systems for exact version support

[2] You can use the latest full-featured backwards compatible SQL Server Management Studio for free. Click here

[3] The minimum required version

[4] Azure DevOps Server (TFS) [5] / Azure DevOps Services

[5] Up to the latest version

[6] Additional 49 MB of disk space is required in case that ApexSQL Updater is not pre-installed on the machine