Table of Contents

Search

  1. Preface
  2. Introduction to Test Data Management
  3. Test Data Manager
  4. Projects
  5. Policies
  6. Data Discovery
  7. Creating a Data Subset
  8. Performing a Data Masking Operation
  9. Data Masking Techniques and Parameters
  10. Plans and Workflows
  11. Monitor
  12. Reports
  13. ilmcmd
  14. Data Type Reference
  15. Data Type Reference for Hadoop

Microsoft SQL Server

Microsoft SQL Server

The following table describes the operations that you can perform on data types in Microsoft SQL Server database:
Data Types
Data Movement
Data Masking
Profiling
Comments
Bigint
Yes
Yes
Yes
Binary
Yes
Yes
No
Use nullification data masking rule to mask the data.
Bit
Yes
Yes
Yes
If you enter data patterns, you must provide T and F values instead of 1 and 0.
Char
Yes
Yes
Yes
Date
Yes
Yes
Yes
Datetime
Yes
No
Yes
You cannot run data domain profiles.
Datetime2
Yes
Yes
No
Datetimeoffset
Yes
No
No
Decimal
Yes
Yes
Yes
You can enter a precision value up to 28.
Float
Yes
Yes
Yes
To perform a data masking operation, you must set the precision to less than 28.
Image
Yes
Yes
No
Int
Yes
Yes
Yes
Money
Yes
Yes
Yes
Nchar
Yes
Yes
Yes
Ntext
Yes
Yes
No
Numeric
Yes
Yes
Yes
You can enter a precision value up to 28.
Nvarchar
Yes
Yes
Yes
Real
Yes
Yes
Yes
Smalldatetime
Yes
No
Yes
You cannot run data domain profiles.
Smallint
Yes
Yes
Yes
Smallmoney
Yes
Yes
Yes
Sql_variant
Yes
No
No
You must increase the precision value after you import metadata.
Text
Yes
Yes
No
Time
Yes
Yes
Yes
When you enter values in milliseconds, TDM truncates the data.
Timestamp
n/a
n/a
No
Tinyint
Yes
Yes
Yes
Uniqueidentifier
Yes
No
Yes
You cannot run data domain profiles.
Varbinary
Yes
Yes
No
Use nullification data masking rule to mask the data.
Varchar
Yes
Yes
Yes
XML
Yes
No
No
You cannot perform data masking, data subset, and profiling operations on the following Microsoft SQL Server data types:
  • Hierarchyid
  • Geography
  • Geometry