Python 3.12 is now available on AppVeyor Windows images. Whilst we're adding that to the mix, I thought we might as well update the build we use too. So this PR uses the Visual Studio 2022 Windows image, instead of 2019. It also uses SQL Server 2019 instead of 2017, Postgresql 13 instead of 11, and MySQL8.0 instead of 5.7 which is now past its EOL.
You have to start MSSQL 2019 with a "net start" command, and MySQL 8.0 with a "Start-Service" command but hopefully those will be cleaned up by AppVeyor at some point.
Python 3.12 is now available on AppVeyor Windows images. Whilst we're adding that to the mix, I thought we might as well update the build we use too. So this PR uses the Visual Studio 2022 Windows image, instead of 2019. It also uses SQL Server 2019 instead of 2017, Postgresql 13 instead of 11, and MySQL8.0 instead of 5.7 which is now past its EOL.
You have to start MSSQL 2019 with a "net start" command, and MySQL 8.0 with a "Start-Service" command but hopefully those will be cleaned up by AppVeyor at some point.