I had recently installed the SQL Toolbelt from Redgate at a client site on a laptop they’d supplied me.
(Fantastic product that SQL Toolbelt BTW.)
Things were going swimmingly – in fact thanks to SQL Compare, SQL Source Control and Team Foundation Server I had implemented an automated Continuous Delivery pipeline for the clients databases and applications.
The next thing I wanted to do was start implementing unit testing for both the applications and database. DEV were going to do the application side (this client is a start-up so it made sense that they had little to no unit tests) and I’d do the database side.
Except in SSMS I couldn’t find SQL Test…??
I knew to click on the icons to bring down other utilities but it wasn’t here either:
![Redgate SSMS Where is SQL TEST](/wp-content/uploads/legacy/de549769dcbe84276334c402294751ae6aab3c0f/redgate-ssms-where-is-sql-test.png)
So as a windows user I naturally looked in the Windows Apps:
![Redgate No SQLTEST in apps](/wp-content/uploads/legacy/f7c588c8facf58fe6dc3c60cb2a623df4bfad663/redgate-no-sqltest-in-apps.png)
At this point I decided it had to be my machine as I did a google and looked on forums and no one seemed to have experienced this.
So I uninstalled everything – SSMS and the Toolbelt.
Reinstalled everything.
And got this:
It was while clicking around like a madman I found this:
Phew.
And of course now I can do this:
![Redgate Now in my happy place](/wp-content/uploads/legacy/f0a904305786b7732bdb64064377f777968bada1/redgate-now-in-my-happy-place.png)
So if you have recently installed Redgate SQL Toolbelt and can’t find SQL Test – hopefully this blog post will help you.
By the way I do think there was something wrong with the laptop the client gave me as now when I right click I get the ability to run tests:
![Redgate SQL Test context menu](/wp-content/uploads/legacy/4f32bd7ca6fae486ff8c7675f2affad3e8e2acc3/redgate-sql-test-context-menu.png)
So now I can start my unit tests – the good news the DEV team have started theirs and are really getting behind it. I think they’ve got on with it to stop me talking about unit tests…!!
We now have 4 minutes of unit tests per checked in build but that is definitely something I’ll respond to with:
Yip.