Query: Seeking robust automated testing for SQL ETL and stored procedures. We compare legacy input from DTSX executions with expected SQL Server outputs. Any alternative database testing tools?
try using tsqlt, its a testing framework for sql that helps automate testing for stored procs and etl routines. i’ve had some luck with it on legacy systems, maybe it’ll work for you too
Based on my experience, leveraging a combination of custom scripts and dedicated testing frameworks can yield effective results. I experimented with Redgate SQL Test, which integrates well with existing development tools and simplifies setting up tests for stored procedures and ETL processes. I also implemented custom PowerShell scripts to validate outputs automatically by comparing run results with known benchmarks. This dual-strategy minimizes manual testing and increases test coverage for complex SQL operations in legacy systems.
hey, i’ve been experimentng with visual studio’s unit test projct for sql, it helps automate etl testing in a seamless way. has anyone tried linking these tests with a ci pipeline? would love to hear about yur experiences.