Need Help with Unit Testing with SQL Server 2019

Jim Dalrymple 20 Reputation points
2023-11-12T23:27:20.2633333+00:00

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.

User's image

Developer technologies | Visual Studio | Testing
SQL Server | Other
0 comments No comments
{count} votes

Accepted answer
  1. Tianyu Sun-MSFT 34,441 Reputation points Microsoft External Staff
    2023-11-13T03:38:43.6033333+00:00

    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

    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.

    1 person found this answer helpful.
    0 comments No comments

0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.