Delphix Products

Expand all | Collapse all

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

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

    Posted 03-07-2019 12:07:00 PM
    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!
    #Masking


  • 2.  RE: How to change the NVARCHAR(MAX) datatype to NVARCHAR(1000) in masking?

    Posted 03-07-2019 12:22:00 PM
    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


  • 3.  RE: How to change the NVARCHAR(MAX) datatype to NVARCHAR(1000) in masking?

    Posted 03-07-2019 12:43:00 PM
    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


  • 4.  RE: How to change the NVARCHAR(MAX) datatype to NVARCHAR(1000) in masking?

    Posted 03-07-2019 12:57:00 PM
    Can you please copy paste the error here ?