SQL Server - testing the database

What tools are people using for testing SQL Server databases?

By this I mean all parts of the database:

  • configuration
  • tables
  • column type
  • stored procedures
  • constraints

Most likely, there is not one tool to do it all.

Answers


How do you mean "Test the database"?

If you are testing foreign keys, a simply script to insert invalid data is all you should need.

Testing a database could imply a great number of issues. Does it have all the tables? Are the tables correct? Are the indexes in place? Did the latest updates get applied? Has the data been migrated? Is the even valid? Are the foreign keys correct?

There is a lot to test in a database so you are unlikely to find a simple way to test it. I find that a combination of test stored procedures and some Nunit unit tests do most of the vetting of my databases.


Need Your Help

Inserting greater/less than or equal symbol into SQL Server database

sql-server unicode nvarchar

I am trying to insert ≤ and ≥ into a symbol table where the column is of type nvarchar.

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.