Need Help with Unit Testing with SQL Server 2019

Question

I'm trying to follow the Learn webpage for SQL Server 2019 and Unit Testing. Eventually, I'd like to get to the point of using Test Driven Development. I've seen Learn pages for that too. Right now, I'm looking at https://learn.microsoft.com/en-us/sql/ssdt/walkthrough-creating-and-running-a-sql-server-unit-test?view=sql-server-ver15. In the Create a Database Project area, it mentions using Installed Templates. I don't see any of the templates in SSMS that are mentioned on this page or the others. I only see those in the attached image. What am I missing? Thank you.

Answer 1

Hello @Jim Dalrymple ,

Welcome to Microsoft Q&A forum.

Looks like you are creating a new project in SSMS? If so, I think you may need to try to create the SQL Server Database Project in Visual Studio.

Not very sure the edition of VS that you are using, in VS 2017, the SQL Server node mentioned in the document exists, see following screenshot:

And in VS 2022, you can directly search for the SQL Server Database Project(make sure that the "Data storage and processing" workload has been installed, VS Installer > Modify > Workloads).

Sincerely,

Tianyu

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.