System requirements

Supported software

ApexSQL Analyze
Hardware	Dual Core 2.0 GHz CPU 4GB memory 112 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	.NET Framework 4.7.2 or higher
Permissions and additional requirements	Windows user account with administrative privileges See Minimum permissions required to install and use ApexSQL products See Minimum SQL Server permissions for ApexSQL Developer tools See Remote access for SQL Server instance

ApexSQL Audit
Hardware	Quad-core 2.0 GHz CPU 8GB memory 1GB disk space (for starting the Central repository database - disk space requirements depend on the amount of audited data and can go to TB for some environments)
SQL Server	SQL Server 2005 and higher [1]
OS	Windows 7 SP1/Windows Server 2008 R2 SP1 and higher [1]
Port	TCP port 64561 on all SQL Server instances (configurable)
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

ApexSQL Build
Hardware	Dual Core 2.0 GHz CPU 3 GB memory 133 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	.NET Framework 4.7.2 or higher
Note	Source control integration available for Azure DevOps [4], Git [5], Mercurial [5], Subversion [5] and Perforce [5]
Permissions and additional requirements	Windows user account with administrative privileges See Minimum permissions required to install and use ApexSQL products See Minimum SQL Server permissions for ApexSQL Developer tools See Remote access for SQL Server instance

ApexSQL Compare
Hardware	Dual Core 2.0 GHz CPU 2 GB memory 103 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	.NET Framework 4.7.2 or higher
Permissions and additional requirements	Windows user account with administrative privileges See Minimum permissions required to install and use ApexSQL products See Minimum SQL Server permissions for ApexSQL Developer tools See Remote access for SQL Server instance

ApexSQL Complete
Hardware	Dual Core 2.0 GHz CPU 4 GB memory 99 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	.NET Framework 4.7.2 or higher
Permissions and additional requirements	Windows user account with administrative privileges See Minimum permissions required to install and use ApexSQL products See Minimum SQL Server permissions for ApexSQL Developer tools See Remote access for SQL Server instance

ApexSQL Data Diff
Hardware	Dual Core 2.0 GHz CPU 3 GB memory 205 MB disk space
SQL Server	SQL Server 2005 and higher [1] Azure SQL Database [1] Amazon RDS for SQL Server [1]
Add-in integration	Visual Studio 2010 and higher [1] Server Management Studio 2012 and higher [2]
OS	Windows 7 SP1/Windows Server 2008 R2 SP1 and higher [1]
Software	.NET Framework 4.7.2 or higher
Note	Source control integration available for Azure DevOps [4], Git [5], Mercurial [5], Subversion [5] and Perforce [5]
Permissions and additional requirements	Windows user account with administrative privileges See Minimum permissions required to install and use ApexSQL products See Minimum SQL Server permissions for ApexSQL Developer tools See Remote access for SQL Server instance

ApexSQL Decrypt
Hardware	Dual Core 2.0 GHz CPU 3 GB memory 80 MB disk space
SQL Server	SQL Server 2005 and higher [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	.NET Framework 4.7.2 or higher
Permissions and additional requirements	Windows user account with administrative privileges See Minimum permissions required to install and use ApexSQL products See Minimum SQL Server permissions for ApexSQL Developer tools See Remote access for SQL Server instance

ApexSQL Defrag
Hardware	Dual Core 2.0 GHz CPU 3 GB memory 133 MB disk space
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 2019 R2 [3] ApexSQL Data Diff 2019 [3] ApexSQL Diff 2019 [3] ApexSQL Doc 2019 [3] ApexSQL Enforce 2019 [3] ApexSQL Generate 2020 [3] ApexSQL Mask 2019 R4 [3] ApexSQL Refactor 2020 [3] ApexSQL Script 2020 [3] ApexSQL Trigger 2019 [3] ApexSQL Unit Test 2019 [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]
Permissions and additional requirements	Windows user account with administrative privileges See Minimum permissions required to install and use ApexSQL products See Minimum SQL Server permissions for ApexSQL Developer tools See Remote access for SQL Server instance See How to setup image based database provisioning
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	253 MB disk space
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 245 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	.NET Framework 4.7.2 or higher
Note	Source control integration available for Azure DevOps [4], Git [5], Mercurial [5], Subversion [5] and Perforce [5]
Permissions and additional requirements	Windows user account with administrative privileges See Minimum permissions required to install and use ApexSQL products See Minimum SQL Server permissions for ApexSQL Developer tools See Remote access for SQL Server instance

ApexSQL Discover
Hardware	Dual Core 2.0 GHz CPU 3 GB memory 80 MB disk space
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
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 Doc
Hardware	Dual Core 2.0 GHz CPU 4 GB memory 123 MB disk space
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 [2] Visual Studio 2010 and higher [1]
OS	Windows 7 SP1/Windows Server 2008 R2 SP1 and higher [1]
Software	.NET Framework 4.7.2 or higher Help Compiler Active Scripting enabled for current zone
Permissions and additional requirements	Windows user account with administrative privileges See ApexSQL Doc – Permissions and requirements See Remote access for SQL Server instance

ApexSQL Enforce
Hardware	Dual Core 2.0 GHz CPU 3 GB memory 114 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	.NET Framework 4.7.2 or higher
Permissions and additional requirements	Windows user account with administrative privileges See Minimum permissions required to install and use ApexSQL products See Minimum SQL Server permissions for ApexSQL Developer tools See Remote access for SQL Server instance

ApexSQL Generate
Hardware	Dual Core 2.0 GHz CPU 3 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 [2]
OS	Windows 7 SP1/Windows Server 2008 R2 SP1 and higher [1]
Software	.NET Framework 4.7.2 or higher
Permissions and additional requirements	Windows user account with administrative privileges See Minimum permissions required to install and use ApexSQL products See Minimum SQL Server permissions for ApexSQL Developer tools See Remote access for SQL Server instance

ApexSQL Job
Hardware	Dual Core 2.0 GHz CPU 3 GB memory 89 MB disk space
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
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	.NET Framework 4.7.2 or higher
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 187 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 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
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 118 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	.NET Framework 4.7.2 or higher
Permissions and additional requirements	Windows user account with administrative privileges See Minimum permissions required to install and use ApexSQL products See Minimum SQL Server permissions for ApexSQL Developer tools See Remote access for SQL Server instance

ApexSQL Model
Hardware	Dual Core 2.0 GHz CPU 4 GB memory 101 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 [2]
OS	Windows 7 SP1/Windows Server 2008 R2 SP1 and higher [1]
Software	.NET Framework 4.7.2 or higher
Permissions and additional requirements	Windows user account with administrative privileges See Minimum permissions required to install and use ApexSQL products See Minimum SQL Server permissions for ApexSQL Developer tools See Remote access for SQL Server instance

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	.NET Framework 4.7.2 or higher
Permissions and additional requirements	Windows user account with administrative privileges See Minimum permissions required to install and use ApexSQL products See Minimum SQL Server permissions for ApexSQL Developer tools See Remote access for SQL Server instance

ApexSQL Propagate
Hardware	Dual Core 2.0 GHz CPU 3 GB memory 93 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	.NET Framework 4.7.2 or higher
Permissions and additional requirements	Windows user account with administrative privileges See Minimum permissions required to install and use ApexSQL products See Minimum SQL Server permissions for ApexSQL Developer tools See Remote access for SQL Server instance

ApexSQL Pump
Hardware	Dual Core 2.0 GHz CPU 3 GB memory 168 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	.NET Framework 4.7.2 or higher
Permissions and additional requirements	Windows user account with administrative privileges See Minimum permissions required to install and use ApexSQL products See Minimum SQL Server permissions for ApexSQL Developer tools See Remote access for SQL Server instance

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	.NET Framework 4.7.2 or higher
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 85 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 or higher [1]
Software	.NET Framework 4.7.2 or higher
Permissions and additional requirements	Windows user account with administrative privileges See Minimum permissions required to install and use ApexSQL products See Minimum SQL Server permissions for ApexSQL Developer tools See Remote access for SQL Server instance

ApexSQL Script
Hardware	Dual Core 2.0 GHz CPU 3 GB memory 173 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	.NET Framework 4.7.2 or higher
Note	Source control integration available for Azure DevOps [4], Git [5], Mercurial [5], Subversion [5] and Perforce [5]
Permissions and additional requirements	Windows user account with administrative privileges See Minimum permissions required to install and use ApexSQL products See Minimum SQL Server permissions for ApexSQL Developer tools See Remote access for SQL Server instance

ApexSQL Search
Hardware	Dual Core 2.0 GHz CPU 4 GB memory 94 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	.NET Framework 4.7.2 or higher
Permissions and additional requirements	Windows user account with administrative privileges See Minimum permissions required to install and use ApexSQL products See Minimum SQL Server permissions for ApexSQL Developer tools See Remote access for SQL Server instance

ApexSQL Search for MySQL
Hardware	Dual Core 2.0 GHz CPU 4 GB memory 94 MB disk space
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]
Add-in integration	Visual Studio 2015 and higher
OS	Windows 7 SP1/Windows Server 2008 R2 SP1 and higher [1]
Software	.NET Framework 4.7.2 or higher
Permissions and additional requirements	MySQL for Visual Studio 1.2.9 or higher Windows user account with administrative privileges

ApexSQL Source Control
Hardware	Dual Core 2.0 GHz CPU 4 GB memory 153 MB disk space (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 [2]
OS	Windows 7 SP1/Windows Server 2008 R2 SP1 or higher [1]
Software	.NET Framework 4.7.2 or higher
Note	Source control integration available for Azure DevOps [4], Git [5], Mercurial [5], Subversion [5] and Perforce [5]
Permissions and additional requirements	Windows user account with administrative privileges See Minimum permissions required to install and use ApexSQL products See Permissions in ApexSQL Source Control See Remote access for SQL Server instance

ApexSQL Trigger
Hardware	Dual Core 2.0 GHz CPU 4 GB memory 112 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 or higher [1]
Software	.NET Framework 4.7.2 or higher
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 See Minimum permissions required to install and use ApexSQL products See ApexSQL Trigger and ApexSQL Trigger Viewer – Permissions and requirements See Remote access for SQL Server instance

ApexSQL Unit Test
Hardware	Dual Core 2.0 GHz CPU 4 GB memory 63.1 MB disk space
SQL Server	SQL Server 2005 and higher [1]
Add-in integration	SQL Server Management Studio 2012 and higher [2]
OS	Windows 7 SP1/Windows Server 2008 R2 SP1 or higher [1]
Software	.NET Framework 4.7.2 or higher
Note	The most recent version of tSQLt can be found on this link
Permissions and additional requirements	Windows user account with administrative privileges See Minimum permissions required to install and use ApexSQL products See Minimum SQL Server permissions for ApexSQL Developer tools See Remote access for SQL Server instance

[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

Get the ApexSQL newsletter

You'll receive

Database administration
Automate critical tasks for database administration

Database development
Integrate database changes and automate deployments

System requirements

Get the ApexSQL newsletter

You'll receive

Database administrationAutomate critical tasks for database administration

Database developmentIntegrate database changes and automate deployments

System requirements

Database administration
Automate critical tasks for database administration

Database development
Integrate database changes and automate deployments