A Visual Studio Test Adapter for discovering and executing tSQLt tests. This will work with an SSDT project or any project that has .sql files with the tests in.
To execute the tests you will need a .runsettigs file with the connection string to the database where the tests are actually deployed to.