Configure a ledger database

1. Open the Azure portal and create an Azure SQL Database .

2. On the Security tab, select Configure ledger.

   

3. On the Configure ledger pane, select Enable for all future tables in this database.

   

4. Select Apply to save this setting.

Open a query editor like SQL Server Management Studio (SSMS), Azure Data Studio or SQL Server Data Tools (SSDT) in Visual Studio and connect to your logical SQL Server. The below example creates a General Purpose database. The WITH LEDGER=ON clause will create the ledger database.

CREATE DATABASE Database01
	(
	  EDITION = 'GeneralPurpose',
	  SERVICE_OBJECTIVE='GP_Gen5_2',
	  MAXSIZE = 2 GB
	)
	WITH LEDGER = ON;
GO 

Create a single ledger database with the New-AzSqlDatabase cmdlet. The below example creates a serverless database. The parameter -EnableLedger will create the ledger database. Note: Make sure you modify the parameters ServerName and DatabaseName

Write-host "Creating a gen5 2 vCore serverless ledger database..."
$database = New-AzSqlDatabase  -ResourceGroupName $resourceGroupName `
    -ServerName "Server01" `
    -DatabaseName "Database01" `
    -Edition GeneralPurpose `
    -ComputeModel Serverless `
    -ComputeGeneration Gen5 `
    -VCore 2 `
    -MinimumCapacity 2 `
    -EnableLedger
$database

Create a ledger database with the az sql db create command. The following command creates a serverless database with ledger enabled. Note: Make sure you modify the parameters resource-group, server and name

az sql db create \
    --resource-group ResourceGroup01 \
    --server Server01 \
    --name Database01 \
    --edition GeneralPurpose \
    --family Gen5 \
    --capacity 2 \
    --compute-model Serverless \
    --ledger-on

1. Sign into your managed instance using SQL Server Management Studio (SSMS), Azure Data Studio or SQL Server Data Tools (SSDT).

2. Create a ledger database using the following T-SQL statement:

   CREATE DATABASE MyLedgerDB  WITH LEDGER = ON;
   

For more information, see CREATE DATABASE (Transact-SQL).

Create a single ledger database with the New-AzSqlInstanceDatabase cmdlet. The following example creates a ledger database on a specified instance. The parameter -EnableLedger creates the ledger database. Make sure you modify the parameters ResourceGroupName, InstanceName and Name.

Write-host "Creating a ledger database..."
$database = New-AzSqlInstanceDatabase -ResourceGroupName "ResourceGroup01" `
    -InstanceName  "ManagedInstance1" `
    -Name "Database01" `
    -EnableLedger
$database

Create a ledger database with the az sql midb create command. The below example creates a ledger database on a specified instance. Make sure you modify the parameters resource-group, managed-instance and name.

az sql midb create \
    --resource-group ResourceGroup01 \
    --managed-instance Server01 \
    --name Database01 \
    --ledger-on