Most tools that generate test data do so iteratively. But SQL loves set based operations. With a little T-SQL know how, you can create millions of rows of test data in seconds.
You can even leverage public data sources to create more realistic data that conforms to your applications business rules.
No third party tools, just a handful of queries. I’m keeping it simple.
#sql #csharp #testing #database
Blog:
betterwithcode.com/
LinkedIn:
/ jeff-zuerlein-2aa67b7
00:00 Introduction
00:13 Why you should generate test data.
01:11 How much data do you need?
01:48 Fake Data
02:48 Sql loves set based operations.
04:05 Fill the table with fake data.
05:38 Realistic test data
06:23 Populating a parent & child tables.
07:39 Leveraging modulus
08:38 Joining with a case statement.
10:45 Let SQL cook.
Негізгі бет Ғылым және технология T-SQL Skills: Loading Millions Of Rows Of Test Data In Seconds
Пікірлер: 15