We are frequently asked about how to incorporate Test Driven Development Practices to current deployment processes.
On this video I'll guide you on a step-by-step journey of how to create a new test project and align it with your existing SQL Change Automation database code pipeline.

https://documentation.red-gate.com/sca/developing-databases/working-with-the-ssms-add-in/setting-up-a-project-in-ssms/setting-up-a-project-with-a-companion-tsqlt-project-in-ssms#SettingupaprojectwithacompaniontSQLtprojectinSSMS-create-tsqlt-project