In my present project I m testing on reports which needs to be checked everyday manually by executing SQL queries for all columns from source tables, Dims and Facts tables and destination tables. Is it possible to do this Automate....?? Please help me


When I first started out in Technical Operations I would run SQL scripts to verify the ETL processes we had running. Now that I had experience in SQA I would more likely write some unit tests so its easy to tell what failed using the reporting tools or the test runner(s).

You could create unit tests in SQL Server.

You could also create unit tests in Visual Studio using a SQL connection string.

  • Thanks for your suggestion. I'll try creating the unit tests in visual studio. I have the script to connect to database but after that how can i validate the results from 3 different tables – user46586 Dec 3 '20 at 16:26
  • Thanks again for the response Kirbycope. Do you know any online sources that can help me in creating the data driven unit test framework – user46586 Dec 3 '20 at 17:20
  • If the documentation is overwhelming, my go to is YouTube. There's usually some videos that take an hour or so that will really help you understand what the tool can do and if it is right for you. The trick is knowing how to break down your problems into Google-able chucks like, "mstest sql". – kirbycope Dec 3 '20 at 17:30

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.