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

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:

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

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

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