CI / TFS and SQL Server database testing : schema validation with unit tests

Question

What are best practices to perform the Schema-Validation in SQL Server ?

I need to test whether a views, stored-procedure, trigger of function points to an existent and working table (or any other objects) or not, and need to perform this check against all objects in the database. I'd like to avoid people introducing broken code and validate that overall schema which should be in a consistent state before releasing in production.

Shall i do it within unit-testing ? what is the best approach ?

I am using CI / TFS and Visual Studio 2015.

Thanks!

Cece Dong - MSFT · Accepted Answer · 2016-06-20 09:01:55Z

1

You can try to use Code Review Policy, which allows you to enforce Code Reviews at checkin time. In this way, you can prevent from checking in the broken code.

answered Jun 20, 2016 at 9:01

Cece Dong - MSFT

31.3k1 gold badge35 silver badges46 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

user1611183 Over a year ago

Hi Cece, many thanks for your reply .. yes it might be an interesting one to do. However, I am much more interested in a solution where the CI server can check the objects validity itself and get back to users with warnings/errors .. i wonder whether it is possible or not ..

Cece Dong - MSFT Over a year ago

Using Code Review Policy is an easy way, or you may need to create a listener to listen to the GettingEventHandler event. Once the check-in event is triggered, send out a warning. almguide.com/2011/12/tfs-server-side-event-handlers

Collectives™ on Stack Overflow

CI / TFS and SQL Server database testing : schema validation with unit tests

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related