Menu
I would like to receive suggestions on the data generators that are available, for SQL server. If posting a response, please provide any features that you think are important.
I have never used a application like this, so I am looking to be educated on the topic. Thank you.
(My goal is to fill a database with 10,000+ records in each table, to test an application.)
860
SQL Data Generator is a fast, simple tool for generating realistic test data. It can instantly provide generators based on table and column names, field length, data types, and other existing constraints. They can be customized to meet your requirements.
Is SQL Losing Relevance? Despite having a meteoric rise for many years, SQL has been fading as the de-facto choice for software applications that need to work with large datasets at low latencies.
Firstly, I wrote a prc to insert row by row. Then I generate some random data for insert with the NVARCHAR(MAX) column to be a string of 1000 characters. Then use a loop to call the prc to insert the rows. The perf is very bad which takes 48 mins if I use SQL server to log on the database server to insert.
The REST API provides programmatic access to the objects in a SQL Server 2017 Reporting Services report server catalog. Examples of objects are folders, reports, KPIs, data sources, datasets, refresh plans, subscriptions, and more.
I have used the data generator in the past. May be worth a look.
If you do not register you can only generate 100 rows. Below you can find a sample how the interface looks today (october 2016)
108
Something similar has been asked here : Creating test data in a database
Red Gate SQL Data Generator does a great job in that domain. You can customize every field of your database and using random data with seeds. And even create specific patterns using Regex expressions.
44
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
