Activity overview
Latest activity by catalogdb
#2 is burning issue. Please guide us to resolve this. / comments
#2 is burning issue. Please guide us to resolve this.
Hi Jessica, - Can you please click on the option at the bottom of the error window to send in a report and send one in with your email address included (the one used to log into the forum)? Error message is empty. However, I solved the issue by editing create test class procedure. It was failing at CREATE SCHEMA step. Just changed it to EXEC ('CREATE SCHEMA ' + @QuotedClassName + ' AUTHORIZATION [dbo]'); - Can you please check your log files in %localappdata%\Red Gate\logs\SQL Test 4 for any related errors? - Can I also please check which Azure authentication mode you are using? I am using AAD Integrated method to connect to azure sql. / comments
Hi Jessica, - Can you please click on the option at the bottom of the error window to send in a report and send one in with your email address included (the one used to log into the forum)?Error me...
SQL Tests coverage errors
Hi,I am facing two issues with SQL Tests.1) Unable to create new test class from SSMS. Showing error dialog without details. I am able to create tests from query window without errors. Not getting ...
Same Issue and Fix. Uninstalled Dependency tracker. / comments
Same Issue and Fix. Uninstalled Dependency tracker.
@way0utwest I posted the test code block with all fake names / comments
@way0utwest I posted the test code block with all fake names
tSQLt test with TVP failing to detect the TVP
Hi,I have created a test using SQL test in SSMS and creating migration script in SCA tests project.Now the issue is the SP which I created tSQLt test for require a TVP (table-valued) parameter this...
tSQLt tests from Visual Studio with Azure SQL
Hi I followed the tutorial and it seems this is not applicable for Azure SQL because Azure SQL doesn't support/allow CLR assemblies. I get below errors while setting up the tests project. First whi...
Why SCA is creating a shadow db on Azure when clicked on refresh button
Hi,When I click on refresh button, SCA is creating a new db in the Azure sql. This is a big concern for me because this is additional cost incurring and forgetting to cleanup this after importing m...
Thanks for the reply, Sergio. I am wondering if there is alternate so I don't have to copy the script in migration script. Its definitely an additional task that I like to avoid if its possible. / comments
Thanks for the reply, Sergio. I am wondering if there is alternate so I don't have to copy the script in migration script. Its definitely an additional task that I like to avoid if its possible.
Calling a new SP/function from migration script.
Hi,I have a need to call newly added stored procedure from the migration scripts. Issue#1The issue is SCA is failing during deployment when the migration script is run because the new stored proced...