** this is out-dated but may still be useful **
these are the masking types and subtypes available for the file generated by New-DbaDbMaskingConfig to execute against Invoke-DbaDbDataMasking.
MaskingType | SubType | ||||||||||||||||||||||||||||||||||||||||||||
Address | BuildingNumber | CardinalDirection | City | CityPrefix | CitySuffix | Country | CountryCode | County | Direction | FullAddress | GetNotifier | Latitude | Longitude | OrdinalDirection | SecondaryAddress | State | StateAbbr | StreetAddress | StreetName | StreetSuffix | ZipCode | Random | |||||||||||||||||||||||
Commerce | Categories | Color | Department | GetNotifier | Price | Product | ProductAdjective | ProductMaterial | ProductName | Random | |||||||||||||||||||||||||||||||||||
Company | Bs | CatchPhrase | CompanyName | CompanySuffix | GetNotifier | Random | |||||||||||||||||||||||||||||||||||||||
Context | Add | Clear | Contains | ContainsKey | ContainsValue | CopyTo | GetEnumerator | GetObjectData | OnDeserialization | Remove | TryGetValue | Comparer | Count | IsFixedSize | IsReadOnly | IsSynchronized | Keys | SyncRoot | Values | ||||||||||||||||||||||||||
Database | Collation | Column | Engine | GetNotifier | Type | Random | |||||||||||||||||||||||||||||||||||||||
Date | Between | BetweenOffset | Future | FutureOffset | GetNotifier | Month | Past | PastOffset | Recent | RecentOffset | Soon | SoonOffset | Timespan | Weekday | Random | ||||||||||||||||||||||||||||||
Finance | Account | AccountName | Amount | Bic | BitcoinAddress | CreditCardCvv | CreditCardNumber | Currency | EthereumAddress | GetNotifier | Iban | RoutingNumber | TransactionType | Random | |||||||||||||||||||||||||||||||
Hacker | Abbreviation | Adjective | GetNotifier | IngVerb | Noun | Phrase | Verb | Random | |||||||||||||||||||||||||||||||||||||
Hashids | Decode | DecodeHex | DecodeLong | Decrypt | DecryptHex | Encode | EncodeHex | EncodeLong | Encrypt | EncryptHex | |||||||||||||||||||||||||||||||||||
Image | Abstract | Animals | Business | Cats | City | DataUri | Fashion | Food | GetNotifier | Image | Nature | Nightlife | People | Sports | Technics | Transport | Random | ||||||||||||||||||||||||||||
IndexFaker | CompareTo | GetTypeCode | ToBoolean | ToByte | ToChar | ToDateTime | ToDecimal | ToDouble | ToInt16 | ToInt32 | ToInt64 | ToSByte | ToSingle | ToType | ToUInt16 | ToUInt32 | ToUInt64 | ||||||||||||||||||||||||||||
IndexGlobal | CompareTo | GetTypeCode | ToBoolean | ToByte | ToChar | ToDateTime | ToDecimal | ToDouble | ToInt16 | ToInt32 | ToInt64 | ToSByte | ToSingle | ToType | ToUInt16 | ToUInt32 | ToUInt64 | ||||||||||||||||||||||||||||
IndexVariable | CompareTo | GetTypeCode | ToBoolean | ToByte | ToChar | ToDateTime | ToDecimal | ToDouble | ToInt16 | ToInt32 | ToInt64 | ToSByte | ToSingle | ToType | ToUInt16 | ToUInt32 | ToUInt64 | ||||||||||||||||||||||||||||
Internet | Avatar | Color | DomainName | DomainSuffix | DomainWord | ExampleEmail | GetNotifier | Ip | Ipv6 | Mac | Password | Protocol | Url | UrlWithPath | UserAgent | UserName | Random | ||||||||||||||||||||||||||||
Locale | Clone | CompareTo | Contains | CopyTo | EndsWith | GetEnumerator | GetTypeCode | IndexOf | IndexOfAny | Insert | IsNormalized | LastIndexOf | LastIndexOfAny | Normalize | PadLeft | PadRight | Remove | Replace | Split | StartsWith | Substring | ToBoolean | ToByte | ToChar | ToCharArray | ToDateTime | ToDecimal | ToDouble | ToInt16 | ToInt32 | ToInt64 | ToLower | ToLowerInvariant | ToSByte | ToSingle | ToType | ToUInt16 | ToUInt32 | ToUInt64 | ToUpper | ToUpperInvariant | Trim | TrimEnd | TrimStart | Length |
Lorem | GetNotifier | Letter | Lines | Paragraph | Paragraphs | Sentence | Sentences | Slug | Text | Word | Words | Random | |||||||||||||||||||||||||||||||||
Name | FindName | FirstName | FullName | GetNotifier | JobArea | JobDescriptor | JobTitle | JobType | LastName | Prefix | Suffix | HasFirstNameList | Random | SupportsGenderFirstNames | SupportsGenderLastNames | SupportsGenderPrefixes | |||||||||||||||||||||||||||||
Person | GetNotifier | Address | Avatar | Company | Context | DateOfBirth | FirstName | FullName | Gender | LastName | Phone | Random | UserName | Website | |||||||||||||||||||||||||||||||
Phone | GetNotifier | PhoneNumber | PhoneNumberFormat | Random | |||||||||||||||||||||||||||||||||||||||||
Random | AlphaNumeric | ArrayElement | ArrayElements | Bool | Byte | Bytes | Char | Chars | ClampString | CollectionItem | Decimal | Digits | Double | Enum | Even | Float | Guid | Hash | Hexadecimal | Int | ListItem | ListItems | Long | Number | Odd | RandomLocale | Replace | ReplaceNumbers | ReplaceSymbols | SByte | Short | Shuffle | String | String2 | UInt | ULong | UShort | Uuid | WeightedRandom | Word | Words | WordsArray | |||
Rant | GetNotifier | Review | Reviews | Random | |||||||||||||||||||||||||||||||||||||||||
System | AndroidId | ApplePushToken | BlackBerryPin | CommonFileExt | CommonFileName | CommonFileType | DirectoryPath | Exception | FileExt | FileName | FilePath | FileType | GetNotifier | MimeType | Semver | Version | Random | ||||||||||||||||||||||||||||
UniqueIndex | CompareTo | GetTypeCode | ToBoolean | ToByte | ToChar | ToDateTime | ToDecimal | ToDouble | ToInt16 | ToInt32 | ToInt64 | ToSByte | ToSingle | ToType | ToUInt16 | ToUInt32 | ToUInt64 |