OrchardCMS / OrchardCore

Orchard Core is an open-source modular and multi-tenant application framework built with ASP.NET Core, and a content management system (CMS) built on top of that framework.
https://orchardcore.net
BSD 3-Clause "New" or "Revised" License
7.23k stars 2.34k forks source link

Document SQL Server minimum requirements #8395

Open Skrypt opened 3 years ago

Skrypt commented 3 years ago

Add somewhere in the documentation SQL Server minimum requirements. While we are at it we should also probably investigate minimum requirement for MySQL and PostgreSQL. Or simply advise to use the current latest versions as it is developed against these.

agriffard commented 3 years ago

Can you please list the minimum requirements for each db provider?

Skrypt commented 3 years ago

That would take a while to figure out every intricacies between versions. We develop against latest versions most of the time. We know that right now we have a limitation with SQL Server under 2016. But, I think that the appropriate thing would be to document that we can create SQLDialects for these.

Though, the appropriate thing to do would be to document what we currently support (all the latests versions).

Also, I think this should be back tracked in YesSQL repository where the PR concerning thse SQLDialects should be made.

See https://github.com/sebastienros/yessql/issues/346

deanmarcussen commented 3 years ago

For info the current versions YesSql is tested against.

      image: postgres:11

      mysql:
        image: mysql:8

      mssql:
        image: mcr.microsoft.com/mssql/server:2019-latest

think we're safe to safe MS SQL 2016 here as well, but should probably bring it into the test matrix at some point