Comments
Sort by recent activity
Hello, I came across the need for this again this week, and posted it as an issue on the SQLCover github page. Eddie replied confirming that SQLCover already has the ability to take a filter to exclude specific objects ("sp_.*diagram" would work in this instance) but there is nothing in the SQLTest ui to allow you to specify anything that can be passed to SQLCover.
Is this something which could be added to SQLTest? Link to GitHub comment : https://github.com/GoEddie/SQLCover/issues/45#issuecomment-548136446
/ comments
Hello, I came across the need for this again this week, and posted it as an issue on the SQLCover github page.Eddie replied confirming that SQLCover already has the ability to take a filter to excl...
Thanks for confirming that @Alex B. / comments
Thanks for confirming that @Alex B.
Thanks for the reply Alex, sorry this reply took so long. What you've mentioned above sounds like it should exclude most of them, but it doesn't line up with what I can see. When I run my tests on a database which has the diagramming objects, these ones show up in the Code coverage section.
[dbo].[sp_upgraddiagrams]
7
0
0.00
[dbo].[sp_helpdiagrams]
5
0
0.00
[dbo].[sp_helpdiagramdefinition]
16
0
0.00
[dbo].[sp_creatediagram]
21
0
0.00
[dbo].[sp_renamediagram]
25
0
0.00
[dbo].[sp_alterdiagram]
24
0
0.00
[dbo].[sp_dropdiagram]
16
0
0.00
[dbo].[fn_diagramobjects]
19
0
0.00
I am using the latest available version - SQL Test Version 3.1.3.585 / comments
Thanks for the reply Alex, sorry this reply took so long.What you've mentioned above sounds like it should exclude most of them, but it doesn't line up with what I can see.When I run my tests on a ...
I'm not sure what the initial problem was, but I have had another go and have it working now.
The error log messages weren't being recorded, so must have been something with the DLM Automation side (or permissions) rather than the SQL Monitor side.
I updated the TFS plugins and DLM Automation 2 to the latest versions, and it is working nicely now :simple smile: / comments
I'm not sure what the initial problem was, but I have had another go and have it working now.
The error log messages weren't being recorded, so must have been something with the DLM Automation side...
Hi Mark R,
I sent an email this morning with some thoughts.
I tried the workaround today and it partially works.
It does take the clone off the dashboard, allowing an image to be deleted.
But sometimes the vhd file is locked by the agent, which means the image deletion sometimes doesn't work, and the other times the image does disappear from the dashboard but the vhd file still exists.
The local system administrator can manually remove the lock and then we can clean this up, but this doesn't seem like something we can easily automate.
Now that I know about the locks, I don't know if my suggestions in my email will actually be feasible, but I'm more than happy to discuss it further. / comments
Hi Mark R,
I sent an email this morning with some thoughts.
I tried the workaround today and it partially works.
It does take the clone off the dashboard, allowing an image to be deleted.
But somet...
We too would benefit greatly from support for clustered instances.
Like rpriesing, we also have our test environment clustered, so it mirrors production.
We were planning on utilising SQL Clone on this server too, both as a source and a destination.
One example of what we were thinking of doing on this instance was spinning up clones for staging environments from an image of a production backup, so it can be blown away and re-cloned if the release script didn't work / needed modifications. / comments
We too would benefit greatly from support for clustered instances.
Like rpriesing, we also have our test environment clustered, so it mirrors production.
We were planning on utilising SQL Clone on ...
I don't think so for us. Most of the time we sit on our primary node unless we were testing patches etc. So having the ability to stand-up clones on even one of the nodes would be helpful for us. It would be great if they failed-over onto the other node in the case of a fail-over, but our immediate desire would be just to have them available on the primary node. / comments
I don't think so for us. Most of the time we sit on our primary node unless we were testing patches etc. So having the ability to stand-up clones on even one of the nodes would be helpful for us. I...
Thanks for your response Andrew.
My environment looks a little different to your screenshots, and I can't see a link button to bring up the "Link Settings" window that you have. [image]
Maybe we are using different versions? I am using "Redgate DLM Automation 2:Build".
I had a go at adding multiple classes straight into the "Run only specified class/test" option but it wouldn't run any tests when I did this.
Can you think of anything else I can try? / comments
Thanks for your response Andrew.
My environment looks a little different to your screenshots, and I can't see a link button to bring up the "Link Settings" window that you have.
Maybe we are using ...
Thanks Alex!
I tried changing that option in the Comparisons options and now it works perfectly [image]
I think I missed that comparisons options screen completely when I was trying to find such a setting, as I thought the text "Comparison options" was a heading rather than a link to a screen of options.
Thank you again for your help, as it was the last thing standing in my way from using this product on a new project.
Cheers,
David. / comments
Thanks Alex!
I tried changing that option in the Comparisons options and now it works perfectly
I think I missed that comparisons options screen completely when I was trying to find such a setting...
I would also love this feature.
I don't suppose you have an update on this? / comments
I would also love this feature.
I don't suppose you have an update on this?