Skip to main content

SQL Server Data Tools: Run SQL Server unit tests during your CI build

Last week I explained how to configure a CI build for your SQL Server Database project. This week we’ll continue by adding Unit testing into the mix.

Before we can run our test, we need to have one. So let’s start by adding a unit test to your database project. One way to do this is to click on a stored procedure, function,etc…  and choose Create Unit Tests…

image

On the Create Unit Tests screen, specify the Test project you want to use(or create a new one), choose a good class name and click OK.

image

Before we run our database test, we’ll have to specify which database we’ll use. Therefore right click on your test project and choose SQL Server Test Configuration…

image

Choose the database where you want to run your test. Optionally you can specify a different connection string(using different credentials) to run the test validations.

image

This is enough to run your tests locally, but if you want to integrate them into your CI build, we’ll have some extra work to do. First of all, we need to add an extra line to set the VisualStudioVersion environment variable in our test code.  If we don’t do this MSBuild will try to use the v11.0 tools and fail to deploy since they aren’t installed on our build controller.

image

We also have to do the same thing inside our build definition. So let’s open up our Build Definition again and add an extra build parameter: /p:VisualStudioVersion=12.0

image

That’s it! Time to check-in all our changes, and see how our build (hopefully) turns green again…

image

Popular posts from this blog

DevToys–A swiss army knife for developers

As a developer there are a lot of small tasks you need to do as part of your coding, debugging and testing activities.  DevToys is an offline windows app that tries to help you with these tasks. Instead of using different websites you get a fully offline experience offering help for a large list of tasks. Many tools are available. Here is the current list: Converters JSON <> YAML Timestamp Number Base Cron Parser Encoders / Decoders HTML URL Base64 Text & Image GZip JWT Decoder Formatters JSON SQL XML Generators Hash (MD5, SHA1, SHA256, SHA512) UUID 1 and 4 Lorem Ipsum Checksum Text Escape / Unescape Inspector & Case Converter Regex Tester Text Comparer XML Validator Markdown Preview Graphic Color B

Help! I accidently enabled HSTS–on localhost

I ran into an issue after accidently enabling HSTS for a website on localhost. This was not an issue for the original website that was running in IIS and had a certificate configured. But when I tried to run an Angular app a little bit later on http://localhost:4200 the browser redirected me immediately to https://localhost . Whoops! That was not what I wanted in this case. To fix it, you need to go the network settings of your browser, there are available at: chrome://net-internals/#hsts edge://net-internals/#hsts brave://net-internals/#hsts Enter ‘localhost’ in the domain textbox under the Delete domain security policies section and hit Delete . That should do the trick…

Azure DevOps/ GitHub emoji

I’m really bad at remembering emoji’s. So here is cheat sheet with all emoji’s that can be used in tools that support the github emoji markdown markup: All credits go to rcaviers who created this list.