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 studio 2019 bootstrap