Atlas vs tSQLt

Atlas is a language-independent tool for managing database schemas and migrations through declarative, versioned workflows. It compares a database's current state with a desired schema expressed in HCL, SQL, or an ORM format, then can generate and execute a migration plan. Teams can lint and validate migrations, run safety checks, and test schemas and migrations. The open version supports PostgreSQL, MySQL, MariaDB, SQLite, TiDB, and LibSQL; Pro adds drivers including SQL Server, Oracle, Snowflake, and Databricks. Atlas describes its core engine as open source under Apache 2.0, with advanced features in proprietary versions. Integrations include Kubernetes, Terraform, GitHub Actions, GitLab CI, CircleCI, Bitbucket Pipelines, Azure DevOps, and a Go SDK. Starter is free. Atlas Pro costs $9 per developer per month, plus usage-based pricing for CI/CD pipelines and databases; new users can try Pro for 30 days. Schema Monitoring costs $39 per monitored database per month. Enterprise pricing is custom.

tSQLt is an open-source unit testing framework for Microsoft SQL Server. Developers write tests in T-SQL, organize them in schemas, and define shared setup methods there. Tests run automatically inside transactions to remain independent and reduce cleanup work. For isolation, tSQLt can fake tables and views and create stored procedure spies. Assertions include AssertEquals and AssertEqualsTable, while results can be generated as plain text or XML for continuous integration tools. The project says it works with SQL Server editions from SQL Server 2005 Service Pack 2 onward. tSQLt is self-hosted, released under the Apache 2.0 license, and the listed plan costs nothing. Installation requires running PrepareServer.sql once per server with SA permission, then installing the framework in a development database. The quick start explicitly says never to install tSQLt in production. Redgate SQL Test is named as its preferred SSMS plug-in.