Comments
Sort by recent activity
Good afternoon @arungk thank you for your post. The deadlock is likely because you have more than one rule in a rule block running against the same table. More about ensuring you set up appropriate dependencies to avoid deadlocks can be found here: https://www.red-gate.com/hub/university/sql-provision/masking-rules-and-concepts/rule-blocks-dependencies and more on speeding up substitution rules and improving concurrency can be found here: https://www.red-gate.com/hub/university/sql-provision/performance-enhancement-with-data-masker/ Please let me know how you get on and if there's anything further I can do to help - thank you very much! / comments
Good afternoon @arungk thank you for your post.The deadlock is likely because you have more than one rule in a rule block running against the same table. More about ensuring you set up appropriate ...
Thanks for coming back on this @gbargsley - I believe when calling the command line from PowerShell you can use the ‘&’ call operator (docs here: https://docs.microsoft.com/en-us/powershell/module/microsoft.powershell.core/about/about_operators?view=powershell-6) This should then run the process. Let me know how you get on - thank you very much. / comments
Thanks for coming back on this @gbargsley - I believe when calling the command line from PowerShell you can use the ‘&’ call operator (docs here: https://docs.microsoft.com/en-us/powershell/module/...
Thank you @gbargsley - let me know how you get on and if you have any problems. Just to be on the safe side I would recommend trying to convert a copy of the set separately, just to be sure. Happy to help where I can! / comments
Thank you @gbargsley - let me know how you get on and if you have any problems.Just to be on the safe side I would recommend trying to convert a copy of the set separately, just to be sure.Happy to...
Thanks @gbargsley - Is the file format a .dmsmaskset? If so, Then you should be able to open this in v6 without any issues. If not and it is the older format, then there is a handy Masking Set Converter in the Tools tab of Data Masker v6 which should help you convert the file to be compatible. This would then allow you to utilise the cmdline and PARFILE capabilities to get around the above error. Thank you very much. / comments
Thanks @gbargsley - Is the file format a .dmsmaskset? If so, Then you should be able to open this in v6 without any issues.If not and it is the older format, then there is a handy Masking Set Conve...
Good Afternoon @gbargsley thank you for your post! I have noted 2 things from this error, the first is that you're running an older version of Data Masker (major version 5.6 with Redgate licensing) and the second that you're using the older command line executable. For automation purposes, in v6+ a new command line feature was added that would allow you to circumvent this error and run normally. If you update to, at the very least, v6.0 but preferably the newest version and then utilise the PARFILE based cmdline to call your masking set, you should find that this solves your problems - the documentation for this can be found here: https://documentation.red-gate.com/dms6/data-masker-help/version-6-tech-tips/running-data-masker-from-the-command-line and you'll note the usage of this is: 'DMSCmdLine.exe PARFILE=C:\MaskingSets\SamplePARFILE.txt' Please let me know how you get on and if you have any further questions. Thank you very much. / comments
Good Afternoon @gbargsley thank you for your post!I have noted 2 things from this error, the first is that you're running an older version of Data Masker (major version 5.6 with Redgate licensing) ...
Hi @Robb_Keller Thank you for your post, When running masking sets as part of an image or CLone creation workflow, the reports that Data Masker output are written instead to the Clone log locations instead of the one specified in the Misc Setup tab of the tool, for instance, my Data Masking logs are written to the below location on the SQL Clone Server machine: C:\Users\[CloneServerServiceUserName]\AppData\Local\Red Gate\Logs\SQL Clone\Images\dmdatabase2017image_00000100_ick\Creation\[MaskingSetName]\Reports As a side note I should also point out that we would always recommend running masking sets against images and not Clones, the reason for this is that running masking sets against the Clones will cause data differences which in turn will cause the Clone differencing disk to bloat and take up additional space. Let me know if you have any further questions thank you very much! / comments
Hi @Robb_Keller Thank you for your post,When running masking sets as part of an image or CLone creation workflow, the reports that Data Masker output are written instead to the Clone log locations ...
Thanks @BobF, as one of the Pre-Sales folk here at Redgate, that's awesome to hear! Have a great day [image] / comments
Thanks @BobF, as one of the Pre-Sales folk here at Redgate, that's awesome to hear! Have a great day
Not a problem @BobF - happy to help! [image] Feel free to reach out if there's anything we can do to help with the trial - always happy to help! / comments
Not a problem @BobF - happy to help! Feel free to reach out if there's anything we can do to help with the trial - always happy to help!
Hi @BobF thank you for your post. Data Masker for SQL Server can absolutely be used with Azure SQLDB, when you first set up your controller, tick the box that says Cloud Mode, remember to put in the connection information, then you should be good to go! Let me know if you have any further questions - thank you very much. / comments
Hi @BobF thank you for your post.Data Masker for SQL Server can absolutely be used with Azure SQLDB, when you first set up your controller, tick the box that says Cloud Mode, remember to put in the...
Thanks for your post @Robb_Keller There is a difference between the DataMasker.exe and the DataMaskerCMDLine.exe - the former will accept the substitution of the connection string and you can specify multiple cmdline args, however the latter, which you are trying to use accepts only 1 parameter, the PARFILE. It is specified in more detail here: https://documentation.red-gate.com/dms6/data-masker-help/version-6-tech-tips/running-data-masker-from-the-command-line Let me know if you need any further information or if you have other questions - thank you very much. / comments
Thanks for your post @Robb_Keller There is a difference between the DataMasker.exe and the DataMaskerCMDLine.exe - the former will accept the substitution of the connection string and you can speci...