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/R2 | Windows 2008 | Windows 2008 R2 | Windows 2012 | Windows 2012 R2 | Windows 2016 | |
| Staging Target Environment | ||||||
| Windows 2003 SP2/R2 | X | X | X | X | X | X |
| Windows 2008 | X | X | X | X | X | |
| Windows 2008 R2 | X | X | X | X | ||
| Windows 2012 | X | X | X | |||
| Windows 2012 R2 | X | X | ||||
| 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 2005 | SQL Server 2008 | SQL Server 2008 R2 | SQL Server 2012 | SQL Server 2014 | SQL Server 2016 | |
| Source Environment | ||||||
| SQL Server 2005 | X | |||||
| 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 2005 | SQL Server 2008 | SQL Server 2008 R2 | SQL Server 2012 | SQL Server 2014 | SQL Server 2016 | |
| Source Environment | ||||||
| SQL Server 2005 | X | X | X | X | ||
| SQL Server 2008 | X | X | X | X | X | |
| SQL Server 2008 R2 | X | X | X | X | ||
| SQL Server 2012 | X | X | X | |||
| SQL Server 2014 | X | X | ||||
| 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 2005 | SQL Server 2008 | SQL Server 2008 R2 | SQL Server 2012 | SQL Server 2014 | SQL Server 2016 | SQL Server 2017 | |
|---|---|---|---|---|---|---|---|---|
| Supported OS Version | ||||||||
| Win 2003 SP2 | Supported | Supported | Supported | N/A | N/A | N/A | N/A | |
| Win 2008 | Supported | Supported | Supported | Supported | Supported | N/A | N/A | |
| Win 2008 SP2 | Supported | Supported | Supported | Supported | Supported | N/A | N/A | |
| Win 2008 R2 | Supported | Supported | Supported | Supported | Supported | N/A | N/A | |
| Win 2008 R2 SP1 | Supported | Supported | Supported | Supported | Supported | N/A | N/A | |
| Win 2012 | N/A | Supported | Supported | Supported | Supported | Supported in 5.1.4+ | Not Supported | |
| Win 2012 R2 | N/A | Supported | Supported | Supported | Supported | Supported in 5.1.4+ | Not Supported | |
| Win 2016 | N/A | N/A | N/A | Supported in 5.1.8+ | Supported in 5.1.8+ | Supported in 5.1.7+ | Not Supported | |
