dbForge Data Generator for SQL Server allows you to create, save, and use your own custom data generators that would better meet your needs, instead of customizing the predefined generators over and over again. You can add one or more custom generators to the existing categories: Business, Health, Location, IT, Payment, Personal, and Product.
You can create a custom generator in two ways - on the basis of a template or from scratch.
dbForge Data Generator for SQL Server is supplied with a wide collection of generator templates that can be easily used for creation of your own data generators.
To create a custom generator based on a template:
The following example is based on the Regular Expression Generator, which is most frequently customized.
|Category||the category a custom generator is added to|
|Name||the name of a generator being added|
|ShortName||the name of a generator that will be displayed in the Preview window|
|Description||the description of a generator|
|Type||the type of a basic generator on which a created generator is based|
|Language||a language to assign a generator depending on a user’s locale|
|ColumnTypes||data types for which a generator will be available|
|Options||contains other tags for configuring a generator, depending on a generator type|
|table=””||a name of the matched table(s)|
|column=””||a name of the matched column(s)|
||any number of characters|
|^||strict beginning of a name, i.e. “^Test.*” means that the beginning of the name must be “Test”, followed by any characters (the valid table names may be the following: test, testing, Test123, etc.)|
|$||strict end of a name, i.e. “.*Test$” means that the end of the name must be “Test”, preceded by any characters (the valid table names may be the following: test, myTest, 123test, etc.)|
|priority=”n”||mapping priority - the rule according to which a generator is automatically assigned to a column (the higher the number, the higher the priority; for the custom generators it should be higher than 4 because the default data type generators have a priority range of between 1 and 4)|
|minlen=”n”||the minimum permissible length of a column (the parameter is ignored for varchar(max), nvarchar(max), text, ntext, image, and varbinary(max))|
|maxlen=”n”||the maximum length of a column (this parameter is optional; the parameter is ignored for varchar(max), nvarchar(max), text, ntext, image, and varbinary(max))|