Techiio-author
Started by Natasha JonesSep 30, 2021

Open
SQL data generation

1 VIEWES 0 LIKES 0 DISLIKES SHARE
0 LIKES 0 DISLIKES 1 VIEWES SHARE

Are there any way to generate data into table automatically? I have try with dbForce data generator. Now i am researching how to generate sql data by flyway but I can't find any docs.

1 Replies

Techiio-commentatorNilima Paul replied 4 months ago0 likes0 dislikes

I once had a customer with software that worked fine in the demo with 30 rows, but after some months, the software had more than a million rows and it became very slow. The problem was not SQL Server, the problem was the application, which was not designed for tables with millions of rows. The customer sued to the software provider and lawyers were needed to create a resolution. If the provider had tested the software with millions of rows, this problem would have never happened.

That is why, it is very important to generate data and test the software with millions of rows. This is not always an easy task. In this article, we will give you some useful T-SQL tips that may help or at least inspire you on this. In general, random data is very useful for testing purposes, to learn about query efficiency, demos and more.

In this article, we will teach how to generate up to a million rows of random data in SQL Server including:

combinations of user names and last names

integer values

real numbers with a specific range

passwords in SQL Server

emails

country names

You must be Logged in to reply
Techiio-logo

Techiio is on the journey to build an ocean of technical knowledge, scouring the emerging stars in process and proffering them to the corporate world.

Follow us on:

Subscribe to get latest updates

You can unsubscribe anytime from getting updates from us
Developed and maintained by Wikiance
Developed and maintained by Wikiance