SSDT: how to create and deploy database unit tests

Question

SSDT: how to create and deploy database unit tests

Parvinder Tomar 146

I have created unit tests in the database project. How do I deploy them? Also, feel free to share if anyone has any documentation on SSDT unit tests.

Oury Ba-MSFT 20,911 Reputation points Microsoft Employee Moderator

2022-06-20T19:41:13.447+00:00

Hi @Parvinder Tomar Thank you for posting your question on Microsoft Q&A.

Are you looking to run SQL server units test in Visual Studio? If yes which version of Studio, are you using?

Regards,
Oury
Parvinder Tomar 146 Reputation points

2022-06-20T20:02:44.407+00:00

Yes, I am using VS-2022
Parvinder Tomar 146 Reputation points

2022-06-20T20:38:09.437+00:00

@Oury Ba-MSFT I am looking to run tests in VS-2022, I can also use VS-2019. I see the example online uses vs 2010. here: https://learn.microsoft.com/en-us/sql/ssdt/walkthrough-creating-and-running-a-sql-server-unit-test?view=sql-server-ver16

I do not find good documentation on what scenarios we should run the tests and also how to deploy them.

any information on this topic will be highly appreciated.

1 answer

Your answer

Oury Ba-MSFT 20,911 Reputation points Microsoft Employee Moderator

2022-06-20T19:41:13.447+00:00

Hi @Parvinder Tomar Thank you for posting your question on Microsoft Q&A.

Are you looking to run SQL server units test in Visual Studio? If yes which version of Studio, are you using?

Regards,
Oury
Parvinder Tomar 146 Reputation points

2022-06-20T20:02:44.407+00:00

Yes, I am using VS-2022
Parvinder Tomar 146 Reputation points

2022-06-20T20:38:09.437+00:00

@Oury Ba-MSFT I am looking to run tests in VS-2022, I can also use VS-2019. I see the example online uses vs 2010. here: https://learn.microsoft.com/en-us/sql/ssdt/walkthrough-creating-and-running-a-sql-server-unit-test?view=sql-server-ver16

I do not find good documentation on what scenarios we should run the tests and also how to deploy them.

any information on this topic will be highly appreciated.

Answer 1

Oury Ba-MSFT 20,911 Microsoft Employee Moderator

Hi @Parvinder Tomar

I do not find good documentation on what scenarios we should run the tests and also how to deploy them.

You create SQL Server unit tests to help identify code defects that might cause incorrect application behavior. For instance, you can create a SQL Server unit test that verifies the behavior of several stored procedures.

First create a SQL server Unit test then use visual studio to run the tests
There are few examples and step by step on how that can be achieved Walkthrough: Creating and Running a SQL Server Unit Test
Then How to: Run SQL Server Unit Tests using Visual studio 2010 and 2012. I am not sure if others version will work.

I can repo this from my end and let you know

Regards,
Oury

Oury Ba-MSFT 20,911 Reputation points Microsoft Employee Moderator

2022-06-23T19:34:17.54+00:00

Hi @Parvinder Tomar Please do not forget to mark as accept answer if the reply is helpful.
If you any further questions, please feel free to comment below so we can continue working on the same.

Regards,
Oury

Share via

SSDT: how to create and deploy database unit tests

1 answer

Your answer