Comments
Sort by recent activity
Thank you @Robb_Keller - the additional information is helpful! I have just checked with the development team to check if this is a feature request we can add in to help, or whether there is some setting that neither of us has caught - I'll come back to you ASAP once I have the answer! / comments
Thank you @Robb_Keller - the additional information is helpful!I have just checked with the development team to check if this is a feature request we can add in to help, or whether there is some se...
Hi @... thank you for your post! You should be able to deactivate your serial on the old computer before you move them onto the new machine by going into the tools and going Help > Deactivate Serial Key If the old machine is no longer available then just fire a quick email to support@red-gate.com who will be able to manually do this from our side, giving you the activation you need for the new machine! Let me know if you have any other questions - thank you very much! / comments
Hi @... thank you for your post!You should be able to deactivate your serial on the old computer before you move them onto the new machine by going into the tools and going Help > Deactivate Serial...
Thank you for coming back on this @kevinumass, If you would like to also mask the ID, as we will be using this numeric value for the table-internal synchronisation rule, it would be better to first mask the ID separately using a Synchronisation Manager rule, you can read more about this type of rule here: https://documentation.red-gate.com/dms6/data-masker-help/version-6-tech-tips/how-do-i-change-a-primary-key-value-and-all-associated-foreign-keys (I realise that ID might not be the Primary Key in this instance, but it will help keep the spread of keys consistent as well as randomly masked. Then you can create a table internal rule for the other fields and make it dependent on the Sync Manager rule and this should solve your problem :simple smile: Let me know how you get on and if there's anything else I can do to help! Thank you very much. / comments
Thank you for coming back on this @kevinumass,If you would like to also mask the ID, as we will be using this numeric value for the table-internal synchronisation rule, it would be better to first ...
Hi kevinumass thank you for your post! Once you have masked the names in the table with a substitution rule, you can run over the table with a table-internal synchronisation rule, which will then take the first value for each key value (in your case ID) and persist the first value down internally to the table. Ultimately this should achieve the result you're looking for but if you have any other questions please feel free to let me know! Thank you very much. / comments
Hi kevinumass thank you for your post!Once you have masked the names in the table with a substitution rule, you can run over the table with a table-internal synchronisation rule, which will then ta...
Thank you for clarifying @AndrewC That makes sense - so in either case we are able to mask the XML, however obviously the second scenario is considerably simpler and involves using an XML masking rule in Data Masker. For the first scenario i described and the one you mentioned, the solution would be to use a Synchronisation manager rule, i.e. take a substitution rule that is masking a regular column (one that also appears in the XML) and then convert it into a sync manager, using a Table-To-Text rule to then sync the same value across both the regular column and the XML. You can find more information on the Sync Manager rule here: https://documentation.red-gate.com/dms6/data-masker-help/version-6-tech-tips/how-do-i-synchronize-changes-to-an-item-with-no-logical-join But if you need further information on this please feel free to let me know! Thank you very much. / comments
Thank you for clarifying @AndrewCThat makes sense - so in either case we are able to mask the XML, however obviously the second scenario is considerably simpler and involves using an XML masking ru...
Hi @AndrewC thank you for your post! By correlated changes do you mean, for example, having a FirstName column, LastName column and an XML field in which FirstName and LastName both exist and you need to sync the masking internally to the XML as a result of what the FirstName and LastName get masked to in the separate columns? Or do you mean that you just need something that is capable of masking both standard fields and also XML fields? Thank you very much. / comments
Hi @AndrewC thank you for your post!By correlated changes do you mean, for example, having a FirstName column, LastName column and an XML field in which FirstName and LastName both exist and you ne...
Hi @Ange thank you for your post! When you say you have lost your masking sets, do you mean they have been accidentally deleted, or you can't remember where they are saved? It might be possible if they still exist and you cannot find them, to locate them either by checking a Data Masker log file / report (stored on the machine where the tool is installed typically) which might identify where they were stored, or alternatively checking any windows scheduler jobs where the tool has been scheduled to run via the command line previously. The Masking Set file is ultimately just an XML file, so it may be recoverable if it has been deleted (and these can be source controlled if you need to do so in future). Unfortunately, there's no way to regenerate the sets from the masking statistics tables as these only store information about the types of rules that were running and how performant / how many rows & columns were masked etc. Apologies if this isn't the most useful answer - but happy to help out however I can! Thank you very much. / comments
Hi @Ange thank you for your post!When you say you have lost your masking sets, do you mean they have been accidentally deleted, or you can't remember where they are saved?It might be possible if th...
Hi @kees thank you for your post. There may be an easier way of achieving this using a Row-Internal Sync rule rather than using a substitution rule, given that we can build some SQL directly into this particular type of rule. What you will need to do here is target the column you're trying to mask (I guess the SSN column) and then select the SSN DataSet as a parameter. Then we just have to cast it to a numeric value like in the attached picture. Let me know if this helps - thank you very much! [image] / comments
Hi @kees thank you for your post.There may be an easier way of achieving this using a Row-Internal Sync rule rather than using a substitution rule, given that we can build some SQL directly into th...
Hi @mujtabazeshan - thank you for your post! It's absolutely possible to do this because this is how a Synchronisation Manager works. It creates a temporary table which selects all distinct values into it, then maps it to a new masked value and then synchronises this back into the column. This operation is used most often to replace all PK and all associated FK values but is also used to retain the spread of values in the way you suggest in your original question. I've included some documentation below for further reading but let me know if you have any issues! Thank you very much. (Using the sync manager discussed here): https://documentation.red-gate.com/dms6/data-masker-help/version-6-tech-tips/how-do-i-synchronize-changes-to-an-item-with-no-logical-join (Point 3 covers a similar topic to what you're asking): https://www.red-gate.com/hub/product-learning/data-masker/approaches-masking-e-mail-addresses / comments
Hi @mujtabazeshan - thank you for your post!It's absolutely possible to do this because this is how a Synchronisation Manager works. It creates a temporary table which selects all distinct values i...
Thank you @mujtabazeshan - and the same to you! Let me know if you have any further issues! / comments
Thank you @mujtabazeshan - and the same to you! Let me know if you have any further issues!