Posts
Sort by recent activity
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 ...
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...
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...
How SCA determines whether a db is empty or not?
Wondering how SCA is determining if DB is empty or not. Because I clearly see there is some difference when I try to deploy a baselined project from VS on an empty db and via ADO CD agent on an emp...
Deploying Baselined SCA project on an empty db using Azure DevOps pipeline
Hi,I am breaking my head since morning to figure out why the baselined script is being marked as deployed despite the db is a fresh, absolutely empty db.As a standard practice, we create Migration/...
Script verification failing with different server/db name
Hi,I updated one of the stored procedure on dev db and tried to refresh the SCA solution to reflect this change. But weirdly, I am getting script verification failed error in the baseline script. T...
Best practice for re-loading Seed Data
Hello,We are loading seed-data as given in documentation with a DELETE operation to avoid duplication.Our seed-data often changes and we have to reload the data again in already deployed environmen...