Need Help with Unit Testing with SQL Server 2019

Jim Dalrymple 20 Reputation points

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 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.

User's image

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
11,561 questions
Visual Studio Testing
Visual Studio Testing
Visual Studio: A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.Testing: The act or process of applying tests as a means of analysis or diagnosis.
306 questions
0 comments No comments
{count} votes

Accepted answer
  1. Tianyu Sun-MSFT 22,096 Reputation points Microsoft Vendor

    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:

    User's image

    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).

    User's image



    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.

    1 person found this answer helpful.
    0 comments No comments

0 additional answers

Sort by: Most helpful