Ledger table not deploying through DACPAC

Arya Basu 0 Reputation points
2023-09-05T15:09:18.7033333+00:00

We are trying to create Append Only Ledger table in Existing Azure SQL, but while we are deploying through DACPAC, It is not

Here is the script for Append only Ledger table in existing Azure SQL

CREATE TABLE [Audit].[AuditEvents]
(
	[AuditId] BIGINT IDENTITY(1, 1) NOT NULL,
    [PatientNo] VARCHAR(50) NULL,
    [TenancyId] INT NULL,
    [EventDate] DATETIME2(7) NOT NULL,
    [EventType] VARCHAR(100) NOT NULL,
    [EntityType] VARCHAR(100) NULL,
    [EventName] VARCHAR(250) NULL,
    [EventMessage] VARCHAR(200) NOT NULL,
    [TileName] VARCHAR(100) NULL,
    [HubReference] VARCHAR(100) NULL,
    [Query] VARCHAR(MAX) NULL,
    [UserId] VARCHAR(100) NULL,
    [AlternativeUserId] VARCHAR(100) NULL,
    [Name] VARCHAR(100) NULL,
    [RoleCode] VARCHAR(100) NULL,
    [UserDefaultTenancyId] INT NULL,
    [SessionType] VARCHAR(100) NULL,
    [SessionGUID] UNIQUEIDENTIFIER NULL,
    [OrganisationIdentifierSystem] VARCHAR(100) NULL,
    [OrganisationIdentifierValue] VARCHAR(100) NULL,
    [OrganisationName] VARCHAR(500) NULL,
    [IPAddress] VARCHAR(40) NULL,
    [ComputerName] VARCHAR(255) NOT NULL,
    [APISubscriptionId] VARCHAR(50) NULL,
    [APISubscriptionName] VARCHAR(100) NULL,
    [APIProduct] VARCHAR(100) NULL,
    [ApplicationComponentId] VARCHAR(50) NULL,
    [ApplicationVersionNumber] VARCHAR(50) NULL,
    CONSTRAINT [PK_Audit] PRIMARY KEY CLUSTERED ([AuditId] ASC)
)
WITH (DATA_COMPRESSION = PAGE, LEDGER = ON (APPEND_ONLY = ON));
GO

But while deploying using DACPAC then the deployment script is removing the LEDGER = ON (APPEND_ONLY = ON)

Here is the deployment script which we got from DACPAC deployment
CREATE TABLE [Audit].[AuditEvents] (     [AuditId]                      BIGINT           IDENTITY (1, 1) NOT NULL,     [PatientNo]                    VARCHAR (50)     NULL,     [TenancyId]                    INT              NULL,     [EventDate]                    DATETIME2 (7)    NOT NULL,     [EventType]                    VARCHAR (100)    NOT NULL,     [EntityType]                   VARCHAR (100)    NULL,     [EventName]                    VARCHAR (250)    NULL,     [EventMessage]                 VARCHAR (200)    NOT NULL,     [TileName]                     VARCHAR (100)    NULL,     [HubReference]                 VARCHAR (100)    NULL,     [Query]                        VARCHAR (MAX)    NULL,     [UserId]                       VARCHAR (100)    NULL,     [AlternativeUserId]            VARCHAR (100)    NULL,     [Name]                         VARCHAR (100)    NULL,     [RoleCode]                     VARCHAR (100)    NULL,     [UserDefaultTenancyId]         INT              NULL,     [SessionType]                  VARCHAR (100)    NULL,     [SessionGUID]                  UNIQUEIDENTIFIER NULL,     [OrganisationIdentifierSystem] VARCHAR (100)    NULL,     [OrganisationIdentifierValue]  VARCHAR (100)    NULL,     [OrganisationName]             VARCHAR (500)    NULL,     [IPAddress]                    VARCHAR (40)     NULL,     [ComputerName]                 VARCHAR (255)    NOT NULL,     [APISubscriptionId]            VARCHAR (50)     NULL,     [APISubscriptionName]          VARCHAR (100)    NULL,     [APIProduct]                   VARCHAR (100)    NULL,     [ApplicationComponentId]       VARCHAR (50)     NULL,     [ApplicationVersionNumber]     VARCHAR (50)     NULL,     CONSTRAINT [PK_Audit] PRIMARY KEY CLUSTERED ([AuditId] ASC) ) WITH (DATA_COMPRESSION = PAGE);

Can you please confirm what is the issue? Why the Ledger option is removing while creating ledger table from DACPAC
Azure SQL Database
{count} votes