SQL Server matrix
Delphix Support Policies specifically list Major and Minor release coverage. If a minor release is listed as covered, then all patch releases under that minor release are certified.
Delphix only supports 64-bit operating systems.
Key:
Color | Supported? |
|---|---|
Y | Yes |
NA | Not Applicable |
Windows server
Supported OS version | Supported DBMS version | |||||
|---|---|---|---|---|---|---|
SQL Server 2012 | SQL Server 2014 | SQL Server 2016 | SQL Server 2017 | SQL Server 2019 | SQL Server 2022 | |
Windows Server 2012 | Y | Y | Y | Y 5.2.3+ | NA | NA |
Windows Server 2012 R2 | Y | Y | Y | Y 5.2.3+ | NA | NA |
Windows Server 2016 | Y 5.1.8+ | Y 5.1.8+ | Y 5.1.8+ | Y | Y 5.3.7+ | Y 8.0.0+ |
Windows Server 2019 | NA | NA | Y 5.3.3+ | Y 5.3.3+ | Y 5.3.7+ | Y 8.0.0+ |
Windows Server 2022 | NA | NA | NA | Y 6.0.13+ | Y 6.0.13+ | Y 8.0.0+ |
Windows support
Delphix supports both "Windows with Desktop Experience" and Windows Core (Windows without Desktop Experience) server installations.
Windows support
After applying Windows updates or .NET updates for Windows Server 2016 or 2019, servers used to host Delphix VDBs may experience the following symptoms:
CPU usage on the Windows target host may increase significantly, possibly reaching 100%.
PowerShell may take up to 10 seconds to launch from the command line.
For more information on how to resolve this issue, see KBA6024
64-bit Windows only
Delphix supports only 64-bit versions of Windows on VDB Target Hosts and Staging Target Hosts. This restriction does not apply to Source Hosts.
Check OS compatibility
The Windows Server OS versions on the Staging Target Hosts and VDB Target Hosts must be compatible. Please refer to the compatibility matrices below.
SQL server failover clusters
There are additional restrictions on supported Windows and SQL Server versions for SQL Server Failover Cluster target environments.
For details, see Adding a SQL Server Failover Cluster Target Environment
Supported SQL versions
SQL server version | Delphix version |
|---|---|
SQL Server 2012 (11.0) | Delphix 3.1.2 and beyond |
SQL Server 2014 (12.0) | Delphix 4.1.3 and beyond |
SQL Server 2016 (13.0) | Delphix 5.1.4 and beyond |
SQL Server 2017 (14.0) | Delphix 5.2.3 and beyond |
SQL Server 2019 (15.0) | Delphix 5.3.7 and beyond |
SQL Server 2022 (16.0) | Delphix 8.0.0 and beyond |
Supported SQL server editions
Standard
Enterprise
Developer
SQL server editions
For Staging Target Hosts, you can use SQL Server Standard Edition only if the source databases do not use SQL Server Enterprise Edition specific features, such as partitioned tables.
However, it is important for VDB target hosts to use the same edition of SQL Server software as the source database so that all features available in the source are also available in the VDB.
Supported Windows connector versions
You can always download the current Windows connector version from the Delphix Engine from the following locations:
Delphix Dynamic Data Platform versions before 6.0.5.0:
http://<name of your Delphix Engine>/connector/DelphixConnectorInstaller.msiDelphix Dynamic Data Platform versions 6.0.5.0 onwards:
http://<name of your Delphix Engine>/connector/DelphixConnectorInstaller.exeThe Delphix Connector and Engine are generally backward-compatible.
Delphix connector version 1.18.0 and beyond is compatible with Delphix Engine 6.0.5.0 and later releases.
Delphix connector version 1.17.0 or earlier is compatible with Delphix Engine 6.0.4.0 and earlier releases
Checking the windows connector version
After installing the connector, you can perform the following steps to determine the Windows connector version.
Navigate to the Windows Environment.
In the search box on the taskbar, type Add or Remove Programs or launch Start > ControlPanel > Programs > Programs and Features.
On the Add or Remove Programs screen, locate Delphix Connector and then click on the software to check the version installed.
Windows connector matrix
The following table details the supported Windows Connector and JRE versions for the corresponding Delphix Dynamic Data Platform versions.
Delphix dynamic data platform version | Windows connector version | JRE version |
|---|---|---|
4.2 | 1.2.0 | 1.7.0_71 (4.2.5.1) |
4.3 | 1.3.0 | 1.8.0_40 (4.3.5.1) |
5.1.0.0-5.1.4.0 | 1.4.0 | 1.8.0_40 |
5.1.5.0 - 5.1.6.0 | 1.5.0 | 1.8.0_112 |
5.1.7.0 | 1.6.0 | 1.8.0_112 |
5.1.8.0 - 5.1.10.0 | 1.7.0 | 1.8.0_112 |
5.2.0.0-5.2.2.0 | 1.9.0 | 1.8.0_131 (5.2.2.1) |
5.2.3.0-5.2.4.0 | 1.10.0 | 1.8.0_162 |
5.2.5.0-5.3.3.0 | 1.12.0 | 1.8.0_202 |
5.3.4.0 | 1.13.0 | 1.8.0_202 |
5.3.5.0 | 1.14.0 | 1.8.0_202 |
5.3.6.0-5.3.7.0 | 1.15.0 | 1.8.0_202 |
5.3.8.0-6.0.0.0 | 1.16.0 | 1.8.0_202 |
6.0.1.0-6.0.4.0 | 1.17.0 | OpenJDK 8u242 |
6.0.5.0-6.0.8.0 | 1.18.0 | OpenJDK 8u262-b10 |
6.0.9.0-6.0.10.0 | 1.20.0 | OpenJDK 8u282-b08 |
6.0.11.0 | 1.21.0.0 | OpenJDK 8u302-b08 |
6.0.12.0 | 1.22.0.0 | OpenJDK 8u302-b08 |
6.0.12.1 | 1.22.0.0 | OpenJDK 8u302-b08 |
6.0.13.0 | 1.23.0.0 | OpenJDK 8u302-b08 |
6.0.13.1 | 1.23.0.0 | OpenJDK 8u302-b08 |
6.0.14.0 | 1.23.0.0 | OpenJDK 8u302-b08 |
6.0.15.0 | 1.24.0.0 | OpenJDK8u332-b09 |
6.0.16.0 | 1.24.0.0 | OpenJDK8u332-b09 |
6.0.17.0 | 1.27.0.0 | OpenJDK 8u345-b01 |
7.0.0.0 | 1.27.0.0 | OpenJDK 8u345-b01 |
8.0.0.0 | 1.27.0.0 | OpenJDK 8u345-b01 |
9.0.0.0 | 1.28.0.0 | OpenJDK 8u362-b09 |
10.0.0.0 | 1.29.0.0 | OpenJDK 8u362-b09 |
11.0.0.0 | 1.30.0.0 | OpenJDK 8u362b09 |
12.0.0.0 | 1.30.0.0 | OpenJDK 8u362b09 |
13.0.0.0 | 1.30.0.0 | OpenJDK 8u362b09 |
14.0.0.0 | 1.31.0.0 | OpenJDK 8u362b09 |
15.0.0.0 | 1.31.0.0 | OpenJDK 8u362b09 |
16.0.0.0 | 1.31.0.0 | OpenJDK 8u362b09 |
The following table details the .Net connector version compatibility for the corresponding Windows Connector versions.
.Net connector version | Windows connector version |
|---|---|
3.5 | 1.17.0 and earlier |
3.5 and 4.0+ | 1.18.0 and higher |
File checksum / hashes
The following table provides the MD5 and SHA256 file hash for recent Delphix versions, in the instance that a security policy requires an exception for software installation.
Delphix dynamic data platform version | Connector version | MD5 Hash | SHA256 Hash |
|---|---|---|---|
6.0.0.0 | 1.16.0 | 84616c4f86c0d871127feb26b9b8bd52 | bc2e5e4b26c33d739f7be12f53637979481e1371325e0b5c7645462f6cf5f4f3 |
6.0.1.0 | 1.17.0 | bb6544dcff3f22d6bf9e20429b1cdb0c | 8d914b77d2c5aa0695c3fdbe7d7394e8ae051c091f6f5ee59185cb1d9d157542 |
6.0.1.1 | 1.17.0 | dd3ea3bedf92a1f8d7e89228315ee315 | 75ed8aa2cf2689916e0b92de6c2aa2fa7660003d62ff07e99978f95dcc9f6abc |
6.0.2.0 | 1.17.0 | 4770f8c1ad46430a1e4b8764ad687ff5 | a98f1c1f90d5053f62d74c1a74bc27b3b48f68a3e067dce04ce9ab2ccf484241 |
6.0.2.1 | 1.17.0 | 97ec3d13db50ad843625b7757c1a2360 | 7c2ab497ae4ac27b907611e976d7068ed8eaf54e52b836591c082bbe01079512 |
6.0.3.0 | 1.17.0 | 3154c7a5fd7bcb4f0e2c66d328290e6a | efb69b2df884705e488d3405a3958c3bb5457142cbfc71990559bb549c2e8c37 |
6.0.3.1 | 1.17.0 | 2f73be2cf8ceef97cf519c716237462d | 7fa7bc269bbc944568231f93ac17ba919b494aa43009967245b75f4abe576a73 |
6.0.4.0 | 1.17.0 | 6a4b7f0a5d180438ff199b2b464506cd | 971b88456574e8e11906b5e6850ea46f012490dcb789a5af73f37d71158ffebf |
6.0.4.1 | 1.17.0 | ea9a564d0cae1066cd9607824292fbd7 | 674f9896360a351b314d6aa6e624f9270ef9e3e8d113baddf028581f1ddddec9 |
6.0.4.2 | 1.17.0 | c5f855c1fa26f5cd3d84d70a94fc0480 | 07d71acafd559e15782e7145225734adf5e50356d2f8abe5a52bbd90f3a44cbe |
6.0.5.0 | 1.18.0 | a3ac768989a6c1dae41adf9452548236 | 71525c31edcf321d2c0220f4edf8932e249e2cd14b261054af1859574dc9e5eb |
6.0.6.0 | 1.18.0 | acb09cbd754e9c25d1afa17b35321cd4 | 3a51bd3b05148dc3563c5b36d83d44ac725295c23c4b7e9c28f54263058fe2b4 |
6.0.6.1 | 1.18.0 | 32202760adb743a62851f8b698a31bf3 | ac16e8a5c37807c2fa775ecc18f9e0387f5bd9d235c9e8854275c99d5bf865a1 |
6.0.7.0 | 1.18.0 | 2fed8da4b986b95a7efb9a9a148239ba | 2c2a83bad568617bf5dd36b84ad0de22b811f113acac45124ed0effbeb6aef17 |
6.0.8.0 | 1.18.0 | 5bf0b950cdcad8c39db60e1a7406d985 | eae5958878a22b4f4f0456210c031ef9c11d064a05ca6cb85535f0e7dec9c0a1 |
6.0.8.1 | 1.18.0 | a3ac768989a6c1dae41adf9452548236 | 71525c31edcf321d2c0220f4edf8932e249e2cd14b261054af1859574dc9e5eb |
6.0.9.0 | 1.20.0 | 127af1d95372f84feb373ab4f7b280b2 | b7c7aaceb2b04aebfbd0ba2521dd15520159d54877b0543567b892ee2584c7ce |
6.0.10.0 | 1.20.0 | e8a39a57e5a77d106d8040a4537bd8f0 | 7d4501bf5f1cf22a7039e8f7429d4b42c0d11b1360434380b174830f1155646e |
6.0.10.1 | 1.20.0 | baf1223b73e626798dd404bd4d18a3c9 | b827d9213e933fce8389322fe25c8d2e1db57ab66709d236b9a8cd5e254bb89d |
6.0.11.0 | 1.21.0.0 | 412c4c32c7aefb973c21b573dca66d2a | 9b689a21249456ddf623042cd2595820531cfbfca0703e713d9795036eef49b7 |
6.0.12.0 | 1.22.0.0 | dc7a97c46ef9e2d91285dcb0712eaf61 | db544774ac3eb3235bf90deef3e93962f3955e86bd9f14309ecb0fba9d41dd7f |
6.0.12.1 | 1.22.0.0 | 8cf9e955438c6393031c5596ca0420cd | 130249658f68eab2a2263deceed6a9de6dd54eead66da68886272f3f40b2f9af |
6.0.13.0 | 1.23.0.0 | 31cc5d3869e4c7f93d38014e5bd40b27 | de1c2fd4c79dcb7391a51774fba1821456ecc031283db5b497145cce383005f2 |
6.0.13.1 | 1.23.0.0 | 3236df25c2e0ab6588bcb54974228b52 | c18adb5e0cce7e40e9fa9552b022973ae468c746aca311df2e58c46ef09749ac |
6.0.14.0 | 1.23.0.0 | 5913ddb3336d571e3ecec1327dcc441c | 11fc899f72239061ff5eaf8d65dcd6de467ba1adcaa7f70c1143f04f22cf14d64 |
6.0.15.0 | 1.24.0.0 | df30e6dc33ef48c839fafdc10726c3a6 | e9f0a139d759b366165fc8ac10361a1a9a0518692f8d4a08cae64c889fd9e753 |
6.0.16.0 | 1.24.0.0 | bd3a63d94b7cf6ec2e3c4b7b0d72415f | 81a91fb9383d125ca123ca959ea69fe980d01dcfe35474774618b34d2f2a8a84 |
6.0.17.0 | 1.27.0.0 | ae36f9bdaef53fc967f6504f679ba6c7 | f036069d6ec056a0a5ab7e38237d05713f207e84c27dcb65c049bafcc9670214 |
7.0.0.0 | 1.27.0.0 | 3257ed8180aaa53b486afe5b78cf00c5 | 742cc206acc59942d4773943a6ecaa978be58c95aa3de65b3621b9fa9b791817 |
8.0.0.0 | 1.27.0.0 | 911b83c5ad4fbdb907c11ab3d0ddac18 | ea0168077bc104ab59b42b6d76f86000f1f0f3b9ee185be1df1a0f6a5cb1c91f |
9.0.0.0 | 1.28.0.0 | 64a245d517f05e72ca80453a6d0bf43c | e8f038626c3e1fd9e5bd1c3a2b30df6e0b5e192713005a03ca3a3d0ab329badf |
10.0.0.0 | 1.29.0.0 | aa88f148d7fbf2988522841aac780020 | b6b5d54be508d9efc2362898a8a8622462fdc42ac15fc3e63d4783edde4c61ee |
11.0.0.0 | 1.30.0.0 | 47a1c9c5817e64f3f68b17e766cac0a | 6266b1f4084c2ea48d922ab5760adad40a730745cd27bfc4bcdcadae7db44bd0 |
12.0.0.0 | 1.30.0.0 | a5ba7f208b474736ee4e0595155d018e | 1622ff824abd56ee8921a75bde4e7012075c31b96aae7fb88ee5cb3d3a3af271 |
13.0.0.0 | 1.30.0.0 | 4e2494ca87ff40f4a17461c3c336dd9d | 1206eb0797cdd5356be39d9822fe4944ada5426734b4f826e5bb3b47c79deb4e |
14.0.0.0 | 1.31.0.0 | bf6a02d54829d974addf7e54744e4ee7 | f185bdca7bd771dda49005d21d03f9cf57dac0f7a909eaab38fab25cbec59dc0 |
15.0.0.0 | 1.31.0.0 | 32936765dd8ce3ad622431aaff7736bc | 45cb3697eb5e82420774ea79c4645a77ce2502fe4751e281ccba259416889cdd |
16.0.0.0 | 1.31.0.0 | dc1dad5da82952461d978c6a4c88d78f | 0da5ae67ee82d2145a6234be27ffe562d289d5cb73ecd32ef30717d35e7c3e03 |
Source environment operating system 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 of the target environments. For more information, see Overview of Setting Up SQL Server Environments
Staging and target environment operating system version compatibility
The operating system version on the target environment that will contain the virtual databases must be equal to or higher than that on the staging target.
Source and staging environment SQL server version compatibility
The SQL Server version on the staging environment must be equal to that on the source environment.
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 Upgrading SQL Server VDBs
Supported SQL server backup software
Delphix currently supports the following software for dSource backups:
SQL Server native backups - all formats, including but not limited to
Striped
Compressed
Append
Overwrite
Veritas NetBackup
Delphix currently supports NetBackup v7.7.3, v8.0, and v8.1.
The version of the NetBackup client on the staging environment must be the same as that on the source.
If the dSource is backed up with NetBackup, the source and staging environments must have a NetBackup client installed.
VDB target environments do not need to have NetBackup installed.Logsync (point-in-time provision) is currently not supported.
See Linking a dSource from a NetBackup SQL Server Backup for more NetBackup requirements and additional information about NetBackup.
Commvault
Delphix currently supports Commvault v11.
The version of Commvault SQL Agent on the staging environment must be the same as that on the source.
If the dSource is backed up with Commvault, the source and staging environment must have Commvault SQL Agent installed.
VDB target environments do not need to have Commvault SQL Agent installed.Commvault SQL Agent on staging environment must be registered to the CommServe server, which is managing source database backups.
Logsync (point-in-time provision) is currently not supported.
See Linking a dSource from a Commvault SQL Server Backup for more Commvault requirements and additional information about Commvault.
Quest/NetVault LiteSpeed
Delphix currently supports LiteSpeed v5.0.0.0 to v8.9.
The LiteSpeed version on the staging environment must be the same or higher than that on the source.
If the dSource is backed up with LiteSpeed, the source and the staging environments must also have LiteSpeed installed.
VDB target environments do not need to have LiteSpeed installed.On source SQL Server Instance, the dSource user must be granted execute privilege on extended stored procedure master.dbo.xp_sqllightspeed_version.
Red Gate SQL Backup Pro
Delphix currently supports SQL Backup Pro v7.3 to v7.7, v8.x, v9.x, and v10.0.
The version of SQL Backup Pro on the staging environment must be the same as that on the source.
On source SQL Server Instance, the dSource database user must be granted execute privilege on extended stored procedure master.dbo.sqbutility.
If the dSource is backed up with SQL Backup Pro, the source and the staging environments must have SQL Backup Pro installed.
VDB target environments do not need to have SQL Backup Pro.
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 2012 | SQL Server 2014 | SQL Server 2016 | SQL Server 2017 | SQL Server 2019 | SQL Server 2022 | |
Source Environment | ||||||
SQL Server 2012 | X | X | X | X | X | X |
SQL Server 2014 | X | X | X | X | X | |
SQL Server 2016 | X | X | X | X | ||
SQL Server 2017 | X | X | X | |||
SQL Server 2019 | X | X | ||||
SQL Server 2022 | X | |||||