tSQLt-Course

Learn how to use tSQLt to professionally unit test T-SQL code. To enroll in the free self-paced course visit here

SQL Cover is a tool to measure code coverage in T-SQL. This will tell you how much of your database code your unit tests are exercising.

You can read more about it:

https://the.agilesql.club/blogs/Ed-Elliott/2016-04-08/SQLCover-Code-Cove...

You can get the source code from:

https://github.com/GoEddie/SQLCover

You can download it from:

https://github.com/GoEddie/SQLCover/releases/

For help feel free to ping me.

Articles / Posts about SQL Cover:

Redgate:

Redgate kindly sponsored the initial version of SQLCover and I am most greatful to David Atkinson who really helped to shape what we have ended up with.

Comments

Hello,

I've just installed the SSDT Dev Pack to have a look at the Code Coverage and am finding the capture runs apparently without problems - And I see "Added 47,406 statements at the end" however then clicking the "Show Code Map" button doesn't do anything so I can't access the results.

The output window (in VS2015) shows

SSDTDevPack: Exception calling ShowCodeMap: System.NotImplementedException: Not implemented (Exception from HRESULT: 0x80004001 (E_NOTIMPL))
at EnvDTE.Project.get_FullName()
at SSDTDevPack.Common.Enumerators.ProjectEnumerator.Get(String projectType)
at SSDTDevPacl.CodeCoverage.Lib.Ui.CodeCoverageWindow.ShowCodeMap(Object sender, RoutedEventArgs e)

Any idea what would cause this or how I can get past this?

Thanks!

Martin

Add new comment

Filtered HTML

  • Web page addresses and e-mail addresses turn into links automatically.
  • Allowed HTML tags: <a> <em> <strong> <cite> <blockquote> <code> <ul> <ol> <li> <dl> <dt> <dd>
  • Lines and paragraphs break automatically.

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.
CAPTCHA
I got fed up of so many spam comments....

Site Search with Duck Duck Go