System requirements

Supported software

ApexSQL Analyze
Hardware	Dual Core 2.0 GHz CPU 4GB memory 100MB 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 Backup
Hardware	Dual Core 2.0 GHz CPU 3 GB memory 200 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
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 Build
Hardware	Dual Core 2.0 GHz CPU 3 GB memory 123 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 95 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 191 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 73 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 130 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 2018 R4 [3] ApexSQL Data Diff 2018 R7 [3] ApexSQL Diff 2018 R5 [3] ApexSQL Doc 2018 R5 [3] ApexSQL Enforce 2018 R7 [3] ApexSQL Generate 2018 R4 [3] ApexSQL Mask 2019 R3 [3] ApexSQL Refactor 2018 R8 [3] ApexSQL Script 2018 R4 [3] ApexSQL Trigger 2018 R3 [3] ApexSQL Unit Test 2018 R4 [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	214 KB disk space
Software	TFS 2015 Update 2 or higher, Azure DevOps Services
Bamboo plug-in
Hardware	1.65 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	500 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	164 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 243 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 163 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 102 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 97 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 87 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 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 88 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 163 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 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 167 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 Source Control
Hardware	Dual Core 2.0 GHz CPU 4 GB memory 147.7 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 106.5 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 56.2 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