Windows Server OS and SQL Server DBMS Compatibility Matrices
Delphix Administration / SQL Server Environments and Data Sources / Setting Up and Configuring Delphix for SQL Server / Tasks for the Windows System Administrator / Windows Server OS and SQL Server DBMS Compatibility Matrices

The matrices in this topic illustrate the compatibility between various versions of SQL Server software used for source, staging target, and provisioning target environments. 

Source Environment OS Compatibility

Source environments can be running any supported Windows operating system version. There are no compatibility requirements between the source environment’s operating system and that on the target environments.

Staging and Provisioning Target Environment OS Compatibility Matrix

The operating system version on the target environment that will contain the virtual databases should be equal to or higher than that on the staging target. For more information, see Overview of Setting Up SQL Server Environments.


Provisioning Target Environment

Windows 2003 SP2/R2Windows 2008Windows 2008 R2Windows 2012Windows 2012 R2Windows 2016
Staging Target Environment





Windows 2003 SP2/R2XXXXXX
Windows 2008
XXXXX
Windows 2008 R2

XXXX
Windows 2012


XXX
Windows 2012 R2



XX
Windows 2016




X

Source and Staging Environment SQL Server Compatibility Matrix

The SQL Server version on the staging environment should be equal to that on the source environment.
 

Staging Target Environment

SQL Server 2005SQL Server 2008SQL Server 2008 R2SQL Server 2012SQL Server 2014SQL Server 2016
Source Environment





SQL Server 2005X




SQL Server 2008
X



SQL Server 2008 R2

X


SQL Server 2012


X

SQL Server 2014



X
SQL Server 2016




X

Source and Provisioning Environment SQL Server Compatibility Matrix

When provisioning a VDB, the SQL Server version on the target should be equal to or higher than that on the source.
 

Provisioning Target Environment

SQL Server 2005SQL Server 2008SQL Server 2008 R2SQL Server 2012SQL Server 2014SQL Server 2016
Source Environment





SQL Server 2005X

XXX
SQL Server 2008
XX XXX
SQL Server 2008 R2

XXXX
SQL Server 2012


XXX
SQL Server 2014



XX
SQL Server 2016




X

Provisioning to Higher SQL Versions When the Source is SQL Server 2005

For SQL Server 2005, direct provisioning to higher SQL Server versions is only supported for provisioning to SQL Server 2012 or higher. You can first provision a VDB to SQL Server 2005 and then upgrade it to a higher version by following the steps outlined in the topic Upgrading SQL Server VDBs.

SQL Server Support Matrix

Delphix only supports 64-bit operating systems.

Windows Server


Supported DBMS Version		SQL Server 2005SQL Server 2008SQL Server 2008 R2SQL Server 2012SQL Server 2014SQL Server 2016SQL Server 2017

Supported OS Version

Win 2003 SP2SupportedSupportedSupportedN/AN/AN/AN/A

Win 2008SupportedSupportedSupportedSupportedSupportedN/AN/A

Win 2008 SP2SupportedSupportedSupportedSupportedSupportedN/AN/A

Win 2008 R2SupportedSupportedSupportedSupportedSupportedN/AN/A

Win 2008 R2 SP1SupportedSupportedSupportedSupportedSupportedN/AN/A

Win 2012N/ASupportedSupportedSupportedSupportedSupported in 5.1.4+Not Supported

Win 2012 R2 N/ASupportedSupportedSupportedSupportedSupported in 5.1.4+Not Supported

Win 2016N/AN/AN/ASupported in 5.1.8+Supported in 5.1.8+Supported in 5.1.7+Not Supported



Related Topics