Activity overview
Latest activity by KVM
Ignore listed errors option
I can't seem to figure out how to get this option to work for me. Not sure if I am just not doing it right or if what I want to do is not possible. I have the following 2 errors that come up ofte...
"Do Nothing" DataSet
What are some examples where using the "Do Nothing" DataSet could be applied?Thanks!
Hello! I applied your suggestions as they fit in each case of the 14 Search and Replace rules. I found some worked with "No Where Clause" and others would error off so those needed "Where Not Null" to be able to run properly. I also grouped the tables where I could to disable and enable indexes. I had significant improvements when the rules ran independent of the full masking run which I attribute to system overhead etc. So thanks for the suggestions. I did have one table that has just over 91 million rows that needed "Where Not Null" to be able to run and did not have any additional indexes. It takes 1.25 hrs to run. I am applying a "Random Replace" to a column that logs changes to the other tables. The data could be anything from dates, names, company names, account numbers, SSN etc. Would you have any suggestion for a different masking approach? Thanks! / comments
Hello!I applied your suggestions as they fit in each case of the 14 Search and Replace rules. I found some worked with "No Where Clause" and others would error off so those needed "Where Not Null"...
Speed up Search and Replace Rules
Are there any tricks or suggestions to speed up search and replace rules?
Well, navigating the XML files was more trouble than it was worth. So, I created backup copies of the files and opened 2 instances of Data Masker, one for each file. I worked across 2 monitors and duplicated it. I thought I might be able to drag and drop between the 2 instances but no. So maybe as a feature request, drag and drop between instances and 'remembering' resized rule edit windows would be helpful. / comments
Well, navigating the XML files was more trouble than it was worth. So, I created backup copies of the files and opened 2 instances of Data Masker, one for each file. I worked across 2 monitors an...
Masking Set Import?
I built a masking set for a single particularly troublesome table as a test. That set is relatively large and wondered, is there was a way to import this set into the set for the entire database? ...
Table-internal sync without a Primary Key and index at rule creation
What happens when a Table-internal sync rule is created when the table does not have a primary key (join columns indicator is red) at rule creation but a primary key is added during masking with a ...
Thank you Chris, That is good and helpful insight on using this product. Much appreciated! / comments
Thank you Chris, That is good and helpful insight on using this product. Much appreciated!
Of the approximately 60 tables that need masking for one database, I have 6 tables without a primary key. My approach was to create a rule block per table. see image. Based on what you said, should my approach be to start with a single command rule and modify all six tables with single refresh in one nested block?[image] [image] / comments
Of the approximately 60 tables that need masking for one database, I have 6 tables without a primary key. My approach was to create a rule block per table. see image. Based on what you said, shou...