Skip to main content
Skip table of contents

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, VDB target hosts need 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:

CODE
http://<name of your Delphix Engine>/connector/DelphixConnectorInstaller.msi

Delphix Dynamic Data Platform versions 6.0.5.0 onwards:

CODE
http://<name of your Delphix Engine>/connector/DelphixConnectorInstaller.exe

The 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.

  1. Navigate to the Windows Environment.

  2. In the search box on the taskbar, type Add or Remove Programs or launch StartControlPanelProgramsPrograms and Features.

  3. 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

17.0.0.0

1.32.0.0

OpenJDK 8u382b05

18.0.0.0

1.33.0.0

OpenJDK 8u382b05

19.0.0.0

1.34.0.0

OpenJDK 8u382b05

20.0.0.0

1.34.0.0

OpenJDK 8u382b05

21.0.0.0

1.34.0.0

OpenJDK 8u382b05

22.0.0.0

1.35.0.0

OpenJDK 8u382b05

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

17.0.0.0

1.32.0.0

34cac1765a2e16da32c05db02714ccb6

8e9eef8feb025b55e3a9f01a0e5bd4293e72d12564a7cec47cae9c311ac6266a

18.0.0.0

1.33.0.0

d1465438ca841c49a1263cc525dfb8c0

6087d2aeea4bbb6abe178b7ac83c382f7b561c43c21086e35f04f8bcc822e681

19.0.0.0

1.34.0.0

011a7f9c6393f44b50e23ff3ccd7c58d

80d50f7892f65b963c6261f81851973d77c9589d70e92a7bfad9acb91806ee8c

20.0.0.0

1.34.0.0

857da97353bc54a6e4b27d5cfb8c56cf

dd7b1bc5c1a4aa8ddcae19d216cca95c9c4c2d7ad478e38574c9315daddd8e69

21.0.0.0

1.34.0.0

82a808fd78031c850fc2bc56526ac147

cce3c0058e0f2b1a6a1e024519d60d9bedb5f5f83009452e31d9a71ca5f5ab99

22.0.0.0

1.35.0.0

075b6146101bc332d0d4ac817b411666

e425a84f7f0abbccc9c05a0c215c96a24462a3bbbcf95183ff372a96d38db20d

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

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.