This will make all tables in this database updatable ledger tables (unless the append only option is enabled for a table). The Enable Ledgercheckbox enables the ledger functionality at the database level. The target platform needs to be set to SQL Server 2022 or Azure SQL Database or Azure SQL MI to make the ledger options available.īuild and publish the ledger tables to a SQL Database.Ī SQL project containing ledger tables can be build and published to an existing or new database in the same way you publish a regular database. Ledger tables can be added from the Solution Explorer as a New Item in a Project. Ledger Tables can be created by right-clicking on the Tables option in Object Explorer. The tables would be visible in the Object Explorer with a unique icon distinguishing the ledger table from others.Ĭreating Ledger Tables, Views from Object Explorer You can connect to these databases and view the ledger tables from the object explorer in SSDT. If you have created ledger tables using applications like SSMS or Azure Data Studio and want to import the Ledger tables into SSDT, then this capability is supported in SSDT. The use cases of Ledger provided in SSDT are as follows: Viewing Ledger Tables & Views in SQL Server Object Explorer (Object Explorer) We are adding Ledger functionality in SSDT like in Azure Data Studio and SSMS. Ledger tables can also find its applications in Multiple-party business processes. It also provides nonrepudiation regarding the integrity of the system’s data. Ledger tables can be used to streamline audits since they provide cryptographic proof of data integrity to auditors. The data is centrally managed, and you can cryptographically attest to other parties, such as auditors or other business parties, that your data is trusted and isn’t tampered with.

Using ledger, the data in SQL is verifiable using the same integrity benefits seen in blockchain technology, while keeping the flexibility, efficiency, and performance of a traditional database. We have added support to SQL Server 2022 from SSDT version 17.5 and with 17.6, we have brought the advanced functionalities that are provided by SQL Server 2022.

Visual code shortcut keys