Author | Sander Stad (@sqlstad, sqlstad.nl) |
Availability | Windows, Linux, macOS |
Want to see the source code for this command? Check out Get-DbaRandomizedType on GitHub.
Want to see the Bill Of Health for this command? Check out Get-DbaRandomizedType.
Lists available data types and subtypes for generating realistic test data during database masking operations
Returns all available randomizer types and subtypes that can be used with Get-DbaRandomizedValue for data masking and test data generation. These types include realistic data patterns like Person names, Address components, Finance data, Internet values, and Random data types. This command helps you discover what fake data options are available when building data masking rules or generating test datasets for non-production environments.
Get-DbaRandomizedType
[[-RandomizedType] <String[]>]
[[-RandomizedSubType] <String[]>]
[[-Pattern] <String>]
[-EnableException]
[<CommonParameters>]
PS > Get-DbaRandomizedType
Get all the types and subtypes
PS > Get-DbaRandomizedType -Pattern "Addr"
Find all the types and sub types based on a pattern
PS > Get-DbaRandomizedType -RandomizedType Person
Find all the sub types for Person
PS > Get-DbaRandomizedType -RandomizedSubType LastName
Get all the types and subtypes that known by "LastName"
Filters results to specific main data categories for realistic test data generation.
Use this when you need to focus on particular data types like Person, Address, Finance, Internet, or Random data.
Available types include Address, Commerce, Company, Database, Date, Finance, Hacker, Image, Internet, Lorem, Name, Person, Phone, Random, System, and more.
Alias | |
Required | False |
Pipeline | false |
Default Value |
Filters results to specific data subtypes within the main categories for precise data masking scenarios.
Use this when you need exact data patterns like FirstName, LastName, Email, CreditCardNumber, or ZipCode.
Subtypes provide granular control over the fake data generation for targeted column masking.
Alias | |
Required | False |
Pipeline | false |
Default Value |
Searches both main types and subtypes using pattern matching to find relevant data generators.
Use this when you're unsure of exact type names or want to discover related options like searching 'Addr' to find Address-related types.
Supports wildcard matching against both Type and SubType columns for flexible discovery.
Alias | |
Required | False |
Pipeline | false |
Default Value |
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.
Alias | |
Required | False |
Pipeline | false |
Default Value | False |