Questions tagged [sql-server-unit-testing]
5 questions
12
votes
3 answers
TSQL Unit Test tools 2017: SQL Server Data Tools 2017 vs tSQLt
I have a new project that needs SQL Server unit test, and CI/CD with VSTS.
Below is the features that are required
SQL server unit test against stored procedure, initial target tables setup for each test and clean up
Unit test in sql
CI/CD with…
Pingpong
- 7,681
- 21
- 83
- 209
11
votes
3 answers
Missing Microsoft.Data.Tools.Schema.Sql.UnitTesting. Again
The bug is very old but MS didn't fix it so far.
I had a VS2015 solution (many projects, with main ASP.NET one) and I opened it in VS 2017.
Here is what I saw when I tried to build it:
So, I figured, okay, some referenced broke, I went into Project…
AgentFire
- 8,944
- 8
- 43
- 90
3
votes
1 answer
Error when adding SQL Server Unit Test item to a Unit Test Project in visual studio 2017
When adding a SQL Server Unit Test item to a Unit Test Project in visual studio 2017 I get the following error:
The reference "Microsoft.VisualStudio.QualityTools.UnitTestFramework,
Version=15.0.0.0, Culture=neutral,…
Simon P Stevens
- 27,303
- 5
- 81
- 107
2
votes
1 answer
Setup Azure SQL database unit test DevOps environment with tSQLt
Environment
Server with Azure SQL
Local with SQL Server Express
Database deploy with SSDT
The plan
[Developer] Run database unit test locally on SQL Server Express during development
[DevOps] Once developer commit the changes, run all unit test…
Bill
- 336
- 4
- 16
1
vote
1 answer
"Cannot access disposed object" Error on VS SQL Unit Testing Project
I have been working on a SQL Server (SSDT) solution on VS 2017, which includes SQL unit test projects that were created by right clicking on items on the SQL project and selecting "Create Unit Tests...".
I configure the connections by right clicking…
Serital
- 343
- 3
- 13