Good day!

Are there any tools for automated testing of databases in MSSQL. For example, projects for Visual Studio (which templates I did not find in the studio itself)?

Share your experiences and links. Thanks in advance.

  • And how do you need to test the database? That there are no scripted objects that reference non-existing tables? This can be verified by recreating them. For this we have an internal utility. - Modus
  • Need to test the integrity of the stored procedure. Found an example on the Habré about Unit testing using .Net tools, which would be very convenient, but the Database Unit Test is only in the Ultimate Studio version. - still1st

1 answer 1

I used TSQLUnit for testing to test SQL code in conjunction with SpecFlow and NUnit .