In case of Visual Studio 2019, they are available as part of standard Visual Studio Installations and in older versions Microsoft has provided all details in MS docs.
SQL Server Data Tools or in short SSDT is part of the Microsoft’s standard tooling for Database version control and release process automation. SQLPackage.exe for Command-line and CICD Integration.Release Management in Database Projects.Publishing Profile and Storing the Profile.Build Actions on SQL Files and their importance.Sample Projects Structure and Problem with Recursive Project References in Visual Studio.You can find solution containing sample projects using this GitHub Repo link. This sample Solution has been made available in public GitHub Repo and details will be shared below. Two related Database Projects will be implemented to add a bit of complexity and discuss specific scenarios that have to be handled using a specific procedure. At the end we will cover the process to automate Release and Deployment Process using available CICD tools and processes. We will start with the basics explaining importance and usage of SSDT followed by a sample implementation covering multiple related Databases. This article spans usage of SQL Server Data Tools (SSDT) and their integration in existing DevOps processes.
SSDT tooling is the Microsoft Standard for Database Version Management and Release Automation.