IOMG Technical Standard: Databases
- All databases for Online Transactional Processing (OLTP) will be Relational Database Management Systems (RDBMS).
- Database Engines will be based on the Structured Query Language (SQL). Where possible transactional SQL (T-SQL) will be the default language.
- Allow for Full, Incremental and Log data backups and restores. Have full compatibility for Microsoft Data Protection Manager using volume shadow copy service (VSS)
- Provide for high availability features such as clustering and availability groups.
- Microsoft SQL Server is the standard choice as this is only system which matches all prerequisites.