IFS Analysis Models - Azure Artifact setup - SQL Database (SQL DB)¶
Azure SQL Database is a fully managed platform as a service (PaaS) database engine that handles most of the database management functions such as upgrading, patching, backups, and monitoring without user involvement. Azure SQL Database is always running on the latest stable version of the SQL Server database engine and patched OS with 99.99% availability. PaaS capabilities built into Azure SQL Database enable you to focus on the domain-specific database administration and optimization activities that are critical for your business.
Each customer has their own SQL Database hosted in the Azure SQL Server. This Database is created using the customer Service Principal
Create SQL DB¶
Note: Dependant on Azure SQL Server
Basics of setting up SQL DB
DB access from SQL Server Management Studio