Microsoft SQL Server
Overview§
SmartPTT supports Microsoft SQL Server as a database and database management servers. The SQL server is used for the following purposes:
- Dispatcher Event Log
- Server Event Log
- Monitoring Database
- Radio User Alias Database
Prerequisites§
The prerequisites are available in the dedicated article.
Changelog§
9.14§
- Introducing manual database upgrades.
- Introducing the support of SQL Server 2022.
9.9§
- Suspending the Metadata MSSQL database due to being unused.
9.2§
- Introducing dedicated MSSQL database for Sign In / Sign Out aliases.
Earlier§
- Introducing additional MSSQL in Server for air traffic and system health events.
- Introducing optional MSSQL in Server for centralized event logging.
- Introducing required MSSQL in Dispatcher App for events logging and configuration.