pennyasfen.blogg.se - Random sql data generator

#RANDOM SQL DATA GENERATOR GENERATOR#

It is presented for all data types except for timestamp, xml, image and server assigned.

#RANDOM SQL DATA GENERATOR GENERATOR#

The Regular expression generator covers a wide spectrum of data types and provides a user with a very high level of data customization. For example, IT area contains the following types: ApexSQL Generate has over 150 predefined lists of values which cover various areas of interest: Personal, Business, Art, Health, Education, Geographical and more:Įach Area contains Types of values. The Predefined generator contains predefined lists of values. Than it has only shared options presented: Usually, it is distinguished by the option of defining the minimum and maximum values, but this isn’t a case when it’s applied on the columns with a bit, SQL_variant, uniqueidentifier, xml or hierarchyid data types. It can be used on all SQL data types except for server assigned: The Random generator is the most commonly used generator. The amount of NULL values is determined by setting the percentage included in this option

Allow null – Enables insertion of NULL values in the current column.

Loop – Allows circular repetition of data so that the desired number of rows can be inserted.

Unique – Ensures that there is no repetition of values in the current column.

Timestamp – Ensures the uniqueness of the generated set of values.

This way, if necessary, the identical set of data can be used on multiple columns

Seed – Each value of the Seed option represents a specific sequence of generated data.

If this option is presented in conjunction with Seed and Timestamp, when it’s unchecked it disables using the Seed and Timestamp options

Shuffle – Randomly reorganizes generated data for a specific column.

Which option is presented for a specific generator depends on the generator itself, as some of these are available only for a specific data types: The application automatically recognizes which generators are suited for each column based on the column name and its data type and only these generators will be presented for that specific column.Īll the generators have some partially shared options.

Data generationĪpexSQL Generate populates SQL databases with synthetic test data by assigning a generator to each column. In this article, we’ll introduce the tools’ core features, describe the main types of generators, walk you through an example and, finally, cover some advanced features. ApexSQL Generate is a test data generation tool for SQL Server.