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. See Setting Up SQL Server Environments: An Overview for more information.
| Provisioning Target Environment |
| Windows 2003 SP2/R2 | Windows 2008 | Windows 2008 R2 | Windows 2012 | Windows 2012 R2 |
Staging Target Environment | | | | | |
Windows 2003 SP2/R2 | X | X | X | X | X |
Windows 2008 | | X | X | X | X |
Windows 2008 R2 | | | X | X | X |
Windows 2012 | | | | X | X |
Windows 2012 R2 | | | | | 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 |
Source Environment | | | | | |
SQL Server 2005 | X | | | | |
SQL Server 2008 | | X | | | |
SQL Server 2008 R2 | | | X | | |
SQL Server 2012 | | | | X | |
SQL Server 2014 | | | | | X |
Source and Provisioning Environment SQL Server Compatibility Matrix
When provisioning a VDB, the SQL Server version on the target can 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 |
Source Environment | | | | | |
SQL Server 2005 | X | | | X | X |
SQL Server 2008 | | X | X | X | X |
SQL Server 2008 R2 | | | X | X | X |
SQL Server 2012 | | | | X | X |
SQL Server 2014 | | | | | X |