Systems - Non Oracle Database Information
Database Platforms
OS Version* | MS SQL Server Database | Exceptions and Additional Information |
|---|---|---|
Windows Server 2019 (64 bit) | SQL Server 2019 SQL Server 2022 | Case-sensitive (CS) collation is not supported for SQL Server. Only case insensitive (CI) collation is supported for SQL Server. |
Windows Server 2022 (64 bit) | SQL Server 2019 SQL Server 2022 | Case-sensitive (CS) collation is not supported for SQL Server. Only case insensitive (CI) collation is supported for SQL Server. |
Windows 10 (64 bit) | SQLite | SQLite is supported only for standalone installation of P6 Professional. |
Windows 11 (64 bit) | SQLite | SQLite is supported only for standalone installation of P6 Professional. |
*OS Version:
Tested with following fully localized international versions of Wndows:
- Arabic
- Brazilian Portuguese
- Chinese Simplified
- Chinese Traditional
- English
- French
- German
- Italian
- Japanese
- Russian
- Spanish
- Korean
- Dutch (Nederlands)
*MS SQL Server Database
P6 Professional supports:
- Hardened database server environment setup SQL Server 2019.
- Cyrillic, Japanese, Chinese/PRC, Chinese/Taiwan, Western European Collation Page for SQL Server databases on the respective operating system locales.
- Oracle recommends LEGACY_CARDINALITY_ESTIMATION be switched on for any version of SQL Server 2019, or later.
Last Published Thursday, May 2, 2024