Are you looking for a tool which can help you generate data for your SQL Server and help you in local/dev performance testing and which is easy to use and understand and most importantly available for free trial.
SQL Data Generator
This is a tool provided by RedGate and available for free trial however to use it for long time you need to purchase a licence.
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.
We are shortly going to see how to use the tool and how to refer the results.
When you open SQL Data Generator the first screen you see is related to server configuration.
The below picture shows the second screen that is shown is the one where actual logic of generating the data is written.
There are several types of data generator options are provided, like Regex generator, SQL Statements, upload from CSV file etc. Based on your table schema you can use whichever type of generator you want for each column.
Hope this will help you in day to day activities.
No comments:
Post a Comment