TSQLT
SDK style database development - part 2
If you went through the first part of this tutorial series, you are going to add an existing project side-by-side you're working project. This is also known as a **composite** project, where you will create a reference to the other main database project, and also include the tSQLt DacPac as a reference for deployment, as this includes all the objects to run tSQLt tests. So, if you did not follow along with the first series, make sure you do that first to follow along with this second part! If you're already there, let's get started
ReadSDK style database development
SQL Server Data Tools (SSDT) is one of the modern development tools to build SQL Server databases. SSDT development is done in Visual Studio, which even in recent years have become smaller in size of the required installations needed to start developing, Microsoft have launched a new release of the SQL Database Projects extension for Azure Data Studio and VS Code. Inside this release, a new preview for an SDK-style SQL project based approach has been introduced, introducing several advantages especially for developers that ship through CI/CD pipelines or are working cross-platform.
Read