Data Types | Test Data Warehouse | Comments |
|---|---|---|
Bigint | Yes | |
Binary | Yes | Use dictionary generation rule to generate test data. Use nullification data masking rule to mask the data. |
Bit | Yes | |
Char | Yes | |
Date | Yes | |
Datetime | Yes | |
Datetime2 | Yes | |
Datetimeoffset | Yes | |
Decimal | Yes | You can enter a precision value up to 28. |
Float | Yes | To perform a data masking operation, you must set the precision to less than 28. When you run a data generation operation, TDM truncates data if the precision is greater than 17. |
Image | Yes | |
Int | Yes | |
Money | Yes | |
Nchar | Yes | |
Ntext | Yes | To perform a reset operation on tables with Ntext data type, create a logical primary key in Test Data Manager if a physical primary key does not exist. |
Numeric | Yes | You can enter a precision value up to 28. |
Nvarchar | Yes | |
Real | Yes | When you run a data generation operation, TDM truncates data if the precision is greater than 15. To perform a reset operation on tables with Real data type, create a logical primary key in Test Data Manager if a physical primary key does not exist. |
Smalldatetime | Yes | |
Smallint | Yes | |
Smallmoney | Yes | |
Sql_variant | Yes | You cannot perform a data masking operation. |
Text | Yes | To perform a reset operation on tables with Text data type, create a logical primary key in Test Data Manager if a physical primary key does not exist. |
Time | Yes | When you enter values in milliseconds, TDM truncates the data. |
Tinyint | Yes | |
Uniqueidentifier | Yes | You cannot assign string masking rule even if the data type is present in the dataMapping.xml file. You cannot perform data generation operations. |
Varbinary | Yes | Use dictionary generation rule to generate test data. Use nullification data masking rule to mask the data. |
Varchar | Yes | |
XML | Yes | You cannot perform a data masking operation. |