Create MS SQL Database With Bicep

This blog post will show you how to create a database on a Microsoft SQL server using a Bicep template.

If you need to create a Microsoft SQL server, please use the following post on creating a Microsoft SQL Server using a Bicep Template.

Bicep Template

The following template will create an SQL Database on an existing SQL Server. The template uses the basic tier for the database.

resource sqlDB 'Microsoft.Sql/servers/databases@2021-08-01-preview' = {
  parent: sqlserver
  name: 'ntweekly'
  location: location
  sku: {
    name: 'basic'
    tier: 'basic'
  }
}