AlexP012
Contributor
Contributor

SQL version for Vcenter

Hi

we're in the process of updating our SQL estate. When I look at the supported SQL version for Vcenter, the compatibility matrix says 6.7 U3 is only supported up to SQL 2016

https://www.vmware.com/resources/compatibility/sim/interop_matrix.php#db&2=

Is this right? Do we have to use a 5 year old version of SQL to be in a supported state? I had hoped to deploy SQL 2017 or 2019

Cheers

Alex

 

0 Kudos
4 Replies
Phil52
Contributor
Contributor

Hello @AlexP012 

I would recommend following the compatibility matrix. 

Do you plan on upgrading to 7.x anytime soon? According to VMware 7.x does not support external databases.

 

vCenter Server 7.0 uses PostgreSQL for the embedded database. vCenter Server 7.0 does not support external databases.

https://docs.vmware.com/en/VMware-vSphere/7.0/com.vmware.vcenter.upgrade.doc/GUID-49E8A38B-A356-4665...

Thanks

0 Kudos
Lalegre
Commander
Commander

Hey @AlexP012,

Yes this is true indeed as @Phil52 mentioned the support in the next versions is deprecated. Adding to his comment I would recommend you to migrate to vCenter Server Appliance if you did not do it yet, assuming your vCenter Server is on Windows.

 

0 Kudos
AlexP012
Contributor
Contributor

Thanks for the replies.  I did wonder why I couldn't see any supported SQL versions for Vcenter 7. I'll have to ask our Vmmare admins what the plan is, I'm the SQL DBA.

0 Kudos
depping
Leadership
Leadership

I would go to the "integrated" database asap. Makes life for everyone easier short term, and long term!

0 Kudos