Get-DbaRandomizedValue

Want to see the source code for this command? Check out Get-DbaRandomizedValue on GitHub.
Want to see the Bill Of Health for this command? Check out Get-DbaRandomizedValue.

Synopsis

This function will generate a random value for a specific data type or bogus type and subtype

Description

Generates a random value based on the assigned sql data type or bogus type with sub type.
It supports a wide range of sql data types and an entire dictionary of various random values.

Syntax

Get-DbaRandomizedValue
    [[-DataType] <String>]
    [[-RandomizerType] <String>]
    [[-RandomizerSubType] <String>]
    [[-Min] <Object>]
    [[-Max] <Object>]
    [[-Precision] <Int32>]
    [[-CharacterString] <String>]
    [[-Format] <String>]
    [[-Symbol] <String>]
    [[-Separator] <String>]
    [[-Value] <String>]
    [[-Locale] <String>]
    [-EnableException]
    [<CommonParameters>]

Examples

Example: 1

PS C:\> Get-DbaRandomizedValue -DataType bit

Will return either a 1 or 0

Example: 2

PS C:\> Get-DbaRandomizedValue -DataType int

Will generate a number between -2147483648 and 2147483647

Example: 3

PS C:\> Get-DbaRandomizedValue -RandomizerSubType Zipcode

Generates a random zipcode

Example: 4

PS C:\> Get-DbaRandomizedValue -RandomizerSubType Zipcode -Format "#### ##"

Generates a random zipcode like "1234 56"

Example: 5

PS C:\> Get-DbaRandomizedValue -RandomizerSubType PhoneNumber -Format "(###) #######"

Generates a random phonenumber like "(123) 4567890"

Optional Parameters

-DataType

The target SQL Server instance or instances.
Supported data types are bigint, bit, bool, char, date, datetime, datetime2, decimal, int, float, guid, money, numeric, nchar, ntext, nvarchar, real, smalldatetime, smallint, text, time, tinyint,
uniqueidentifier, userdefineddatatype, varchar

-RandomizerType

Bogus type to use.
Supported types are Address, Commerce, Company, Database, Date, Finance, Hacker, Hashids, Image, Internet, Lorem, Name, Person, Phone, Random, Rant, System

-RandomizerSubType

Subtype to use.

-Min

Minimum value used to generate certain lengths of values. Default is 1

-Max

Maximum value used to generate certain lengths of values. Default is 255

-Precision

Precision used for numeric sql data types like decimal, numeric, real and float

-CharacterString

The characters to use in string data. 'abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789' by default

-Format

Use specilized formatting with certain randomizer types like phone number.

-Symbol

Use a symbol in front of the value i.e. $100,12

-Separator

Some masking types support separators

-Value

This is the value that needs to be used for several possible transformations.
One example is the subtype "Shuffling" where the value will be shuffled.

-Locale

Set the local to enable certain settings in the masking. The default is 'en'

-EnableException

By default, when something goes wrong we try to catch it, interpret it and give you a friendly warning message.
This avoids overwhelming you with "sea of red" exceptions, but is inconvenient because it basically disables advanced scripting.
Using this switch turns this "nice by default" feature off and enables you to catch exceptions with your own try/catch.