All geek questions in one place

How to generate test data using Visual Studio 2012?

How to create test data using Visual Studio 2012?

I found these 2 articles on how to do this using VS 2010. But what about VS 2012?

My database is SQL-Server 2008 R2 database.

Thanks in advance.

+6
source share
3 answers

Although this feature was in Visual Studio 2010 (if you added VSTE DBPRO), it did not slice for Visual Studio 2012 / SSDT (for now). This does not mean that it will not get into the product until the next release - it is something that can become a set of functions, a power tool, or even in a service pack. The same thing with testing the database modules and the data comparison function .

As I said in a comment, you can use a third-party tool like RedGate SQL Data Generator . Also see this question for some other options. And hang there. :-)

+6
source

Testing database modules is not supported at all in VS 2012.

0
source

Now we will need to rely on third-party tools, as this feature will not be supported by Microsoft in the future. http://blogs.msdn.com/b/ssdt/archive/2013/06/24/announcing-sql-server-data-tools-june-2013.aspx search "Data generation is not included and is not planned to be released in the future"

It doesn’t matter if we use the test development. In TDD we will have a component test touching database (full coverage of the scenario). We could use the same modules to create test data.

0
source

Source: https://habr.com/ru/post/926352/

More articles:


All Articles