SQLTraining2023JSONTemplateSpecDatabases.txt

{
    "$schema": "https://schema.management.azure.com/schemas/2019-04-01/deploymentTemplate.json#",
    "contentVersion": "1.0.0.0",
    "parameters": {
        "sqlServerName": {
            "type": "string",
            "metadata": {
                "description": "The name of the SQL Server."
            }
        },
        "sqlAdministratorLogin": {
            "type": "string",
            "metadata": {
                "description": "The administrator username of the SQL Server."
            }
        },
        "sqlAdministratorLoginPassword": {
            "type": "securestring",
            "metadata": {
                "description": "The administrator password of the SQL Server."
            }
        },
        "databaseName": {
            "type": "string",
            "metadata": {
                "description": "The name of the SQL Database."
            }
        },
        "location": {
            "type": "string",
            "defaultValue": "[resourceGroup().location]",
            "metadata": {
                "description": "Location for all resources."
            }
        }
    },
    "variables": {
        "databaseEdition": "Basic",
        "databaseCollation": "SQL_Latin1_General_CP1_CI_AS",
        "databaseServiceObjectiveName": "Basic"
    },
    "resources": [
        {
            "name": "[parameters('sqlServerName')]",
            "type": "Microsoft.Sql/servers",
            "apiVersion": "2021-05-01-preview",
            "location": "[parameters('location')]",
            "tags": {
                "displayName": "SqlServer"
            },
            "properties": {
                "administratorLogin": "[parameters('sqlAdministratorLogin')]",
                "administratorLoginPassword": "[parameters('sqlAdministratorLoginPassword')]",
                "version": "12.0"
            },
            "resources": [
                {
                    "name": "[parameters('databaseName')]",
                    "type": "databases",
                    "apiVersion": "2022-08-01-preview",
                    "location": "[parameters('location')]",
                    "tags": {
                        "displayName": "Database"
                    },
                    "properties": {
                        "edition": "[variables('databaseEdition')]",
                        "collation": "[variables('databaseCollation')]",
                        "requestedServiceObjectiveName": "[variables('databaseServiceObjectiveName')]",
                        "createMode": "Copy",
                        "sourceDatabaseId": "/subscriptions/19866297-20c6-4921-b541-e867aeda8d3f/resourceGroups/data_engineering_SQL_training_2023/providers/Microsoft.Sql/servers/sqlservermain2023/databases/sqldbmain2023",
                        "zoneRedundant": false,
                        "maxSizeBytes": 34359738368,
                        "readScale": "Disabled",
                        "autoPauseDelay": 60,
                        "minCapacity": 0.5,
                        "isLedgerOn": false,
                        "currentSku": {
                            "name": "GP_S_Gen5",
                            "tier": "GeneralPurpose",
                            "family": "Gen5",
                            "capacity": 1
                        }
                    },
                    "dependsOn": [
                        "[parameters('sqlServerName')]"
                    ]
                }
            ]
        }
    ]
}