snippetsqlMinor
What tools are there to generate test data for SQL Server?
Viewed 0 times
whataresqlgeneratetestforservertoolsdatathere
Problem
As you can see from another question of mine, generating test data is my theme right now.
At this point, I'm still generating my test data by hand. However, this process always generates small amounts of data (usually five-ten rows) since it is a manual process.
Are there any tools to automate this process? Particularly, I'd like to be able to generate 1mil+ rows.
At this point, I'm still generating my test data by hand. However, this process always generates small amounts of data (usually five-ten rows) since it is a manual process.
Are there any tools to automate this process? Particularly, I'd like to be able to generate 1mil+ rows.
Solution
An excellent resource is of course the Redgate SQL Toolbelt, in particular their Data Generator
SQL Data Generator is a fast, simple tool for generating test data.
Using table and column names, field length, data types and other
existing constraints SQL Data Generator immediately provides sensible
generators. These can then be customized to meet specific
requirements.
Ideal for both testing databases and complying with privacy
legislation, SQL Data Generator provides test data fast and simply.
SQL Data Generator is a fast, simple tool for generating test data.
Using table and column names, field length, data types and other
existing constraints SQL Data Generator immediately provides sensible
generators. These can then be customized to meet specific
requirements.
Ideal for both testing databases and complying with privacy
legislation, SQL Data Generator provides test data fast and simply.
Context
StackExchange Database Administrators Q#4814, answer score: 5
Revisions (0)
No revisions yet.