It offers a wide assortment of "generators" that you can select from and assign to each column: simple generators for generating sequential or random INTs and UNIQUEIDENTIFIERs, and weighted-list generators, which let you manually create lists of data and weight the frequency at which each item should appear within the generated results. The tool really shines when you're specifying the kinds of data that you want to generate for each of your tables.
You can also save projects to re-use your specifications and customizations for each data-load operation.
Red gate sql data generator generator#
The intuitive UI uses the concept of "projects": With each project, you point SQL Data Generator at a target database, let it read the schema, then specify how many rows you want loaded into each table. Happily, installation was a breeze and within a few minutes it had generated my data. The first time I used SQL Data Generator, I needed to get it up and running quickly. In all these cases, the tool performed admirably. I’ve also used it to generate a whole suite of intricately related data (nearly 1GB in size) for a sample data warehouse. I've used it to create sample data for development and testing and to quickly populate tables to validate performance requirements and address capacity planning needs. I’ve been using Red Gate Software's SQL Data Generator 1.2 for a while now and have really grown to love it. csv files and other files and to create custom generators. It offers a wide assortment of "generators" that you can select from and assign to each column, as well as canned data generators to generate commonly occurring types of data, plus the ability to import data from. SQL Data Generator is easy to use and generates data quickly.
0 kommentar(er)
