Database

Removed Microsoft SQL Server as a Supported Enterprise Database

Simphony supports only Oracle Database as the enterprise database platform. Customers with enterprise databases running on Microsoft SQL Server must convert them to Oracle Database prior to upgrading.

Note:

The following on-premises services and devices still support Microsoft SQL Server:

• Point-of-Sale Client

• Check and Posting Service

• Kitchen Display Controller Services

Review the Oracle MICROS Simphony Installation Guide and the Oracle MICROS Simphony Post-Installation or Upgrade Guide for more information on installations and upgrades.

Review the Oracle Food and Beverage Compatibility Matrix for more information on supported operating systems and databases.

Improved System Performance

If you are performing an upgrade to Simphony release 19.1 (or importing a database after a fresh installation), the system's performance can be improved by reducing CPU utilization and Disk I/O on database servers. This can be accomplished by performing the steps outlined in the Oracle MICROS Simphony Cloud Services Post-Installation or Upgrade Guide (specifically the Simphony Upgrade Procedures section) prior to performing the upgrade (or immediately after importing a database after a fresh installation).

Support Added for Oracle Container and Pluggable Databases

Simphony now supports Oracle Container and Pluggable Databases (PDB). A PDB is considered a container. A container is a collection of schemas, objects, and related structures in a container database (CDB) that appears logically to Simphony as a separate database. PDBs isolate data and operations so that from a user’s perspective, each PDB appears as if it were a traditional Oracle non-CDB.

See the Oracle MICROS Simphony Installation Guide or the Oracle MICROS Simphony Post-Installation or Upgrade Guide for more information about performing installations or upgrades.