System requirements

Supported software

ApexSQL Analyze
Hardware	Dual Core 2.0 GHz CPU 4GB memory 80MB 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.1 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 5GB 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.1 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 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 BI Monitor
Hardware	Quad-core 3.0 GHz CPU (the specification considers monitoring of 5 SSAS, SSIS, SSRS instances with medium to high activity) 4GB memory 3GB disk space (for 7 days data retention policy - this is an average requirement based on real world use cases, but this could further vary depending on the monitoring instances state/activity)
BI services	SQL Server Analysis Services 2005 and higher [1] SQL Server Integration Services 2005 and higher [1] SQL Server Reporting Services 2005 and higher [1] Azure Analysis Services [1]
OS	Windows 7 SP1 / Windows Server 2008 R2 SP1 and higher [1]
Ports	TCP ports 139, 445 and 1433 (default SQL Server instance port) on monitored machines TCP ports 5005 (http) and 4444 (https) on ApexSQL BI Monitor web server (configurable)
Software	.NET Framework 4.7.1 or higher SQL Server 2008 or higher [1], for Central repository database Internet Explorer 11 or higher Edge build 14393 or higher Chrome 50 or higher Mozilla Firefox 50 or higher Opera 40 or higher
Note	SQL Server Express edition is not recommended for the central repository due to database size limitation
Permissions and additional requirements	Windows user account with administrative privileges See ApexSQL BI Monitor – Permissions and requirements

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
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
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
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
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 66 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.1 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 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.1 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 ApexSQL Build 2018 R4 [3] ApexSQL Data Diff 2018 R6 [3] ApexSQL Diff 2018 R4 [3] ApexSQL Doc 2018 R4 [3] ApexSQL Enforce 2018 R5 [3] ApexSQL Generate 2018 R3 [3] ApexSQL Script 2018 R3 [3] ApexSQL Trigger 2018 R3 [3] ApexSQL Unit Test 2018 R3 [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	14 MB disk space
Software	Atlassian Bamboo 6.6.3 or higher
Jenkins plug-in
Hardware	5.7 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.3 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 238 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
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 73 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.1 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 130 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]
OS	Windows 7 SP1 / Windows Server 2008 R2 SP1 and higher [1]
Software	.NET Framework 4.7.1 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
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
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 69 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.1 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
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 113 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
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
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 Monitor
Hardware	Quad-core 3.0 GHz CPU 4 GB memory 10 GB disk space Note: estimated requirement for monitoring 5 SQL Server instances with medium to high activity and 30 days data retention policy
SQL Server	SQL Server 2005 and higher [1] Azure SQL Database [1] Basic support for Amazon RDS for SQL Server [1]
OS	Windows 7 SP1 / Windows Server 2008 R2 SP1 and higher [1]
Port	TCP ports 139, 445 and 1433 (default SQL Server instance port) on monitored machines TCP ports 5000 (http) and 4443 (https) on ApexSQL Monitor web server (configurable)
Software	.NET Framework 4.7.1 or higher SQL Server 2008 or higher [1], for the Central repository database Internet Explorer 11 or higher Edge build 14393 or higher Chrome 50 or higher Mozilla Firefox 50 or higher Opera 40 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 ApexSQL Monitor - Permissions and requirements

ApexSQL Plan
Hardware	Dual Core 2.0 GHz CPU 4 GB memory 156 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
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 71 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.1 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
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
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 195 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
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 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 [1]
OS	Windows 7 SP1 / Windows Server 2008 R2 SP1 and higher [1]
Software	.NET Framework 4.7.2
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
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
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
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

ApexSQL VM Monitor
Hardware	Quad-core 3.0 GHz CPU (the specification considers monitoring of 5 hosts with medium to high activity) 4 GB memory 30 GB disk space (for 7 days data retention policy - this is an average requirement based on real word use cases, but this could further vary depending on the number of monitored hosts and their state/activity)
Hypervisors	Microsoft Hyper-V 2012 and higher VMware ESXi 5.5 and higher
OS	Windows 7 SP1/Windows Server 2008 R2 SP1 and higher [1]
Port	Port 135 on monitored Microsoft Hyper-V hosts Port 443 on monitored VMware ESXi hosts TCP ports 5010 (http) and 4445 (https) on ApexSQL VM Monitor web server (configurable)
Software	.NET Framework 4.7.1 or higher SQL Server 2008 or higher [1], for Central repository database Internet Explorer 11 or higher Edge build 14393 or higher Chrome 50 or higher Mozilla Firefox 50 or higher Opera 40 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 ApexSQL VM Monitor – Permissions and 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

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