快速入門：建立 Azure SQL Database 單一資料庫Quickstart: Create an Azure SQL Database single database

若要在 Azure 入口網站中建立單一資料庫，本快速入門會從 Azure SQL 頁面開始。To create a single database in the Azure portal this quickstart starts at the Azure SQL page.

1. 瀏覽至選取 SQL 部署選項頁面。Browse to the Select SQL Deployment option page.

2. 在 SQL 資料庫 下，將 資源類型 設定為 單一資料庫，然後選取 [建立]。Under SQL databases, leave Resource type set to Single database, and select Create.

   

3. 在 建立 SQL 資料庫 表單的 基本資料 索引標籤上，在 專案詳細資料 下，選取想要的 Azure 訂用帳戶。On the Basics tab of the Create SQL Database form, under Project details, select the desired Azure Subscription.

4. 針對 資源群組 選取 [建立新的]，輸入 myResourceGroup，然後選取 [確定]。For Resource group, select Create new, enter myResourceGroup, and select OK.

5. 針對 資料庫名稱 輸入 mySampleDatabase。For Database name enter mySampleDatabase.

6. 在 伺服器 中，選取 [建立新的]，並以下列值填寫 新伺服器 表單：For Server, select Create new, and fill out the New server form with the following values:

   • 伺服器名稱：輸入 mysqlserver 並新增一些字元來表示唯一性。Server name: Enter mysqlserver, and add some characters for uniqueness. 由於伺服器名稱必須是 Azure 中所有伺服器的全域唯一名稱，而不只是訂用帳戶中的唯一名稱，因此我們無法提供要使用的確切伺服器名稱。We can't provide an exact server name to use because server names must be globally unique for all servers in Azure, not just unique within a subscription. 因此，請輸入類似 mysqlserver12345 的值，入口網站會讓您知道您輸入的值是否可以使用。So enter something like mysqlserver12345, and the portal lets you know if it is available or not.
   • 伺服器管理員登入：輸入 azureuser。Server admin login: Enter azureuser.
   • 密碼：輸入符合需求的密碼，然後在 [確認密碼] 欄位中再次輸入。Password: Enter a password that meets requirements, and enter it again in the Confirm password field.
   • 位置：從下拉式清單中選取位置。Location: Select a location from the dropdown list.

   選取 [確定]。Select OK.

7. 將 您要使用 SQL 彈性集區 設為 否。Leave Want to use SQL elastic pool set to No.

8. 在 計算 + 儲存體 下，選取 [設定資料庫]。Under Compute + storage, select Configure database.

9. 本快速入門會使用無伺服器資料庫，因此請選取 [無伺服器]，然後選取 [套用]。This quickstart uses a serverless database, so select Serverless, and then select Apply.

   

10. 完成時，選取 [下一步:網路功能]，為於頁面底部。Select Next: Networking at the bottom of the page.

    

11. 在 網路功能 索引標籤的 連線方法 中，選取 [公用端點]。On the Networking tab, for Connectivity method, select Public endpoint.

12. 針對 防火牆規則，將 [新增目前的用戶端 IP 位址] 設定為 是。For Firewall rules, set Add current client IP address to Yes. 將 允許 Azure 服務和資源存取此伺服器群組 保留為 否。Leave Allow Azure services and resources to access this server set to No.

13. 完成時，選取 [下一步:其他設定]，位於頁面底部。Select Next: Additional settings at the bottom of the page.

    

14. 在 [其他設定] 索引標籤的 [資料來源] 區段中，針對 [使用現有的資料]，選取 [範例]。On the Additional settings tab, in the Data source section, for Use existing data, select Sample. 這會建立 AdventureWorksLT 範例資料庫，同時提供一些可供查詢和實驗的資料表和資料，而不是空的空白資料庫。This creates an AdventureWorksLT sample database so there's some tables and data to query and experiment with, as opposed to an empty blank database.

15. 選取頁面底部的 [檢閱 + 建立]：Select Review + create at the bottom of the page:

    

16. 檢閱 [檢閱 + 建立] 頁面之後，選取 [建立]。On the Review + create page, after reviewing, select Create.

啟動 Azure Cloud ShellLaunch Azure Cloud Shell

Azure Cloud Shell 是免費的互動式 Shell，可讓您用來執行本文中的步驟。The Azure Cloud Shell is a free interactive shell that you can use to run the steps in this article. 它具有預先安裝和設定的共用 Azure 工具，可與您的帳戶搭配使用。It has common Azure tools preinstalled and configured to use with your account.

若要開啟 Cloud Shell，只要選取程式碼區塊右上角的 [試試看] 即可。To open the Cloud Shell, just select Try it from the upper right corner of a code block. 您也可以移至 https://shell.azure.com，從另一個瀏覽器索引標籤啟動 Cloud Shell。You can also launch Cloud Shell in a separate browser tab by going to https://shell.azure.com. 選取 [複製] 即可複製程式碼區塊，將它貼到 Cloud Shell 中，然後按 Enter 鍵加以執行。Select Copy to copy the blocks of code, paste it into the Cloud Shell, and press Enter to run it.

設定參數值Set parameter values

後續的命令會使用下列值來建立資料庫和所需的資源。The following values are used in subsequent commands to create the database and required resources. 伺服器名稱在所有 Azure 中必須是全域唯一的名稱，因此會使用 $RANDOM 函式來建立伺服器名稱。Server names need to be globally unique across all of Azure so the $RANDOM function is used to create the server name. 取代 IP 位址範圍中的 0.0.0.0 值，以符合您的特定環境。Replace the 0.0.0.0 values in the ip address range to match your specific environment.

# Set the resource group name and location for your server
resourceGroupName=myResourceGroup
location=eastus

# Set an admin login and password for your database
adminlogin=azureuser
password=Azure1234567!

# Set a server name that is unique to Azure DNS (<server_name>.database.windows.net)
serverName=server-$RANDOM

# Set the ip address range that can access your database
startip=0.0.0.0
endip=0.0.0.0

建立資源群組Create a resource group

使用 az group create 命令來建立資源群組。Create a resource group with the az group create command. Azure 資源群組是在其中部署與管理 Azure 資源的邏輯容器。An Azure resource group is a logical container into which Azure resources are deployed and managed. 下列範例會在 eastus 位置建立名為 myResourceGroup 的資源群組：The following example creates a resource group named myResourceGroup in the eastus location:

az group create --name $resourceGroupName --location $location

建立伺服器Create a server

使用 az sql server create 命令建立伺服器。Create a server with the az sql server create command.

az sql server create \
    --name $serverName \
    --resource-group $resourceGroupName \
    --location $location  \
    --admin-user $adminlogin \
    --admin-password $password

設定伺服器的防火牆規則Configure a firewall rule for the server

使用 az sql server firewall-rule create 命令建立防火牆規則。Create a firewall rule with the az sql server firewall-rule create command.

az sql server firewall-rule create \
    --resource-group $resourceGroupName \
    --server $serverName \
    -n AllowYourIp \
    --start-ip-address $startip \
    --end-ip-address $endip

使用 Azure CLI 建立單一資料庫Create a single database with Azure CLI

使用 az sql db create 命令建立資料庫。Create a database with the az sql db create command. 下列程式碼會建立The following code creates

az sql db create \
    --resource-group $resourceGroupName \
    --server $serverName \
    --name mySampleDatabase \
    --sample-name AdventureWorksLT \
    --edition GeneralPurpose \
    --compute-model Serverless \
    --family Gen5 \
    --capacity 2

您可以使用 Windows PowerShell 來建立資源群組、伺服器及單一資料庫。You can create a resource group, server, and single database using Windows PowerShell.

啟動 Azure Cloud ShellLaunch Azure Cloud Shell

Azure Cloud Shell 是免費的互動式 Shell，可讓您用來執行本文中的步驟。The Azure Cloud Shell is a free interactive shell that you can use to run the steps in this article. 它具有預先安裝和設定的共用 Azure 工具，可與您的帳戶搭配使用。It has common Azure tools preinstalled and configured to use with your account.

若要開啟 Cloud Shell，只要選取程式碼區塊右上角的 [試試看] 即可。To open the Cloud Shell, just select Try it from the upper right corner of a code block. 您也可以移至 https://shell.azure.com，從另一個瀏覽器索引標籤啟動 Cloud Shell。You can also launch Cloud Shell in a separate browser tab by going to https://shell.azure.com. 選取 [複製] 即可複製程式碼區塊，將它貼到 Cloud Shell 中，然後按 Enter 鍵加以執行。Select Copy to copy the blocks of code, paste it into the Cloud Shell, and press Enter to run it.

設定參數值Set parameter values

後續的命令會使用下列值來建立資料庫和所需的資源。The following values are used in subsequent commands to create the database and required resources. 伺服器名稱在所有 Azure 中必須是全域唯一的名稱，因此會使用 Get-Random Cmdlet 來建立伺服器名稱。Server names need to be globally unique across all of Azure so the Get-Random cmdlet is used to create the server name. 取代 IP 位址範圍中的 0.0.0.0 值，以符合您的特定環境。Replace the 0.0.0.0 values in the ip address range to match your specific environment.

   # Set variables for your server and database
   $resourceGroupName = "myResourceGroup"
   $location = "eastus"
   $adminLogin = "azureuser"
   $password = "Azure1234567!"
   $serverName = "mysqlserver-$(Get-Random)"
   $databaseName = "mySampleDatabase"

   # The ip address range that you want to allow to access your server
   $startIp = "0.0.0.0"
   $endIp = "0.0.0.0"

   # Show randomized variables
   Write-host "Resource group name is" $resourceGroupName
   Write-host "Server name is" $serverName

建立資源群組Create resource group

使用 New-AzResourceGroup 來建立 Azure 資源群組。Create an Azure resource group with New-AzResourceGroup. 資源群組是在其中部署與管理 Azure 資源的邏輯容器。A resource group is a logical container into which Azure resources are deployed and managed.

   Write-host "Creating resource group..."
   $resourceGroup = New-AzResourceGroup -Name $resourceGroupName -Location $location -Tag @{Owner="SQLDB-Samples"}
   $resourceGroup

建立伺服器Create a server

使用 New-AzSqlServer Cmdlet 建立伺服器。Create a server with the New-AzSqlServer cmdlet.

  Write-host "Creating primary server..."
   $server = New-AzSqlServer -ResourceGroupName $resourceGroupName `
      -ServerName $serverName `
      -Location $location `
      -SqlAdministratorCredentials $(New-Object -TypeName System.Management.Automation.PSCredential `
      -ArgumentList $adminLogin, $(ConvertTo-SecureString -String $password -AsPlainText -Force))
   $server

建立防火牆規則Create a firewall rule

使用 New-AzSqlServerFirewallRule Cmdlet 建立伺服器防火牆規則。Create a server firewall rule with the New-AzSqlServerFirewallRule cmdlet.

   Write-host "Configuring server firewall rule..."
   $serverFirewallRule = New-AzSqlServerFirewallRule -ResourceGroupName $resourceGroupName `
      -ServerName $serverName `
      -FirewallRuleName "AllowedIPs" -StartIpAddress $startIp -EndIpAddress $endIp
   $serverFirewallRule

使用 PowerShell 建立單一資料庫Create a single database with PowerShell

使用 New-AzSqlDatabase Cmdlet 建立單一資料庫。Create a single database with the New-AzSqlDatabase cmdlet.

   Write-host "Creating a gen5 2 vCore serverless database..."
   $database = New-AzSqlDatabase  -ResourceGroupName $resourceGroupName `
      -ServerName $serverName `
      -DatabaseName $databaseName `
      -Edition GeneralPurpose `
      -ComputeModel Serverless `
      -ComputeGeneration Gen5 `
      -VCore 2 `
      -MinimumCapacity 2 `
      -SampleName "AdventureWorksLT"
   $database

使用 Azure 入口網站來刪除 myResourceGroup 和其所有資源：To delete myResourceGroup and all its resources using the Azure portal:

1. 在入口網站中，搜尋並選取 [資源群組]，然後從清單中選取 [myResourceGroup]。In the portal, search for and select Resource groups, and then select myResourceGroup from the list.
2. 在 [資源群組] 頁面中，選取 [刪除資源群組]。On the resource group page, select Delete resource group.
3. 在 [輸入資源群組名稱] 底下，輸入 myResourceGroup，然後選取 [刪除]。Under Type the resource group name, enter myResourceGroup, and then select Delete.

若要刪除資源群組及其所有資源，請使用您的資源組名稱來執行下列 Azure CLI 命令：To delete the resource group and all its resources, run the following Azure CLI command, using the name of your resource group:

az group delete --name $resourceGroupName

若要刪除資源群組及其所有資源，請使用您的資源組名稱來執行下列 PowerShell Cmdlet：To delete the resource group and all its resources, run the following PowerShell cmdlet, using the name of your resource group:

Remove-AzResourceGroup -Name $resourceGroupName