How to change the NVARCHAR(MAX) datatype to NVARCHAR(1000) in masking?

  • 0
  • 1
  • Question
  • Updated 1 month ago
  • In Progress
How to change the NVARCHAR(MAX) datatype to NVARCHAR(1000) in masking? 
Delphix masking engine not working to mask the data with datatype NVARCHAR(MAX).
So, now I want to know if it is possible to give the alter statement in the prescript and post scripts at masking job? I tried this but no luck. Any suggestion please!
Photo of Rajesh Dadi

Rajesh Dadi

  • 402 Points 250 badge 2x thumb

Posted 1 month ago

  • 0
  • 1
Photo of Mayank Ahluwalia

Mayank Ahluwalia

  • 646 Points 500 badge 2x thumb
Hi Rajesh,

Can you please elaborate what and how are you trying to mask ?

I just tried masking a NVARCHAR(MAX) on my SQL server DB, worked fine


Regards,
Mayank
Photo of Rajesh Dadi

Rajesh Dadi

  • 402 Points 250 badge 2x thumb
Hi Mayank,

If I have a column DESCRIPTION in a table DELPHIX. column's datatype is NVARCHAR(MAX) and want to mask this column with Secure Suffle. When I did this in masking engine, masking job getting failed as NVARCHAR(MAX) is not supporting by Delphix.Yes, we can Alter the dadatype in sql server and do the masking then it is working, but we are not supposed to change it in sql server. I want that to give it as a prescript while creating masking job. Here I am failing to succeed the masking job.

Thanks,
Rajesh
Photo of Mayank Ahluwalia

Mayank Ahluwalia

  • 646 Points 500 badge 2x thumb
Can you please copy paste the error here ?