Comments
Sort by recent activity
HI @PlantBasedSQL
Thanks for the response, the path was right ,but I entered it wrong in my previous post. I have tried multiple syntaxes, ran from command line as batch file and even the syntax that you suggested ,below is the error for both couple of syntaxes and I couldn't see any logs as well. Syntax 1: & "C:\Program Files\Red Gate\Data Masker for SQL Server 7\DataMaskerCmdLine.exe" PARFILE="C:\Users\arun\Desktop\DataMasker\PowerShell\PARFILE.txt" Syntax 2: & "C:\Program Files\Red Gate\Data Masker for SQL Server 7\DataMaskerCmdLine.exe" PARFILE="C:\Users\arun\Desktop\DataMasker\PowerShell\PARFILE.PARFILE"
Error: CmdLineMain: Starting
CmdLineMain: Initializing...
DMS_CmdLine.MaskingSetRunner: Error Processing Command Line: line 3 cannot be processed because it has an unknown keyword.
CmdLineMain: Ending Exit Code=103 PARFILE: MASKINGSET=C:\Users\arun\Desktop\Data Masker\MultipleSchemas.DMSMaskSet
LOGFILEDIR=C:\Data\Data Masker(SqlServer)\Log Files
DATASETDIR=C:\PROGRA~1\Red Gate\Data Masker for SQL Server 7\DataSets
REPORTSDIR=C:\Data\Data Masker(SqlServer)\Reports
INTERIM_REPORTS=true
What should be the PARFILE format, I was using .txt but in your response I see its .PARFIL Thank you / comments
HI @PlantBasedSQL
Thanks for the response, the path was right ,but I entered it wrong in my previous post. I have tried multiple syntaxes, ran from command line as batch file and even the syntax t...
Hi @PlantBasedSQL, @DanC Thank you so much for the responses. The process to delete the data in the image creation process is really good. But just wanted to confirm that deletion won't impact the source data(Prod data in my case) right? I know when the masking script is not impacting the source ,ideally the delete script shouldn't be an issue. Just for the sake of confirmation:) Thank you, Arun / comments
Hi @PlantBasedSQL, @DanC Thank you so much for the responses.The process to delete the data in the image creation process is really good. But just wanted to confirm that deletion won't impact the s...
@PlantBasedSQL Thank you for the explanation I will try this and let you know. / comments
@PlantBasedSQL Thank you for the explanation I will try this and let you know.
HI @PlantBasedSQL Thanks for the explanation .Is there any video course available for the second option that you mentioned ? Thank you, Arun / comments
HI @PlantBasedSQL Thanks for the explanation .Is there any video course available for the second option that you mentioned ?Thank you,Arun
Hi @PlantBasedSQL Thanks for the reply. I have got one more question on this. Is there a way that we can insert the data with Referential Integrity. Like in my masking scenarios that you have suggested in my previous posts, If I have two tables with name columns, PK and FKs, based on PK can I insert the same data into two new tables ? / comments
Hi @PlantBasedSQL Thanks for the reply.I have got one more question on this. Is there a way that we can insert the data with Referential Integrity. Like in my masking scenarios that you have sugges...
Hi @PlantBasedSQL Thanks for the information. I do have one more question ,Can we upload XML files, JSON files into database records using "Insertion"? I have seen that there is an option to insert from Disk ,and those files resides in the "Data sets ".Since I don't have needed privileges, I can't update the data sets and see whether it supports xml, JSON or not Thank you, Arun / comments
Hi @PlantBasedSQL Thanks for the information. I do have one more question ,Can we upload XML files, JSON files into database records using "Insertion"? I have seen that there is an option to insert...
Hi @PlantBasedSQL Thank you so much for the detailed explanation. I will be having a meeting with the tool support team, just wanted to have some things ready before going to that meet. Thank you, Arun / comments
Hi @PlantBasedSQL Thank you so much for the detailed explanation.I will be having a meeting with the tool support team, just wanted to have some things ready before going to that meet.Thank you,Arun
Hi @PlantBasedSQL My bad. I didn't get a chance till today and Yes I did exactly as you mentioned and it's working great. Thanks you soo much:) / comments
Hi @PlantBasedSQL My bad. I didn't get a chance till today and Yes I did exactly as you mentioned and it's working great.Thanks you soo much:)
Hi @PlantBasedSQL, I was able to perform basic XML masking and working on Insertion and Masking multiple tables with synchronization. As you know from our previous conversation I have the same data in 2 tables and I wanted to get the synchronized records after masking. I am able to perform the same in single table but for 2 tables, I even tried multiple ways like having Table-To -Table rules, Synch manager, etc., but couldn't get the results. I am thinking that I have to add some additional rules to my masking set which I used for single table masking. I might be missing the order of rules. Below is the sample data in 2 tables(attaching one screen shot since the same data exists in 2 tables) [image] If you can suggest me a better way that would be great. Thanks, Arun / comments
Hi @PlantBasedSQL,I was able to perform basic XML masking and working on Insertion and Masking multiple tables with synchronization.As you know from our previous conversation I have the same data i...
Hi @PlantBasedSQL Thank you so much for the step by step explanation, it worked well and I've got the expected results. In my Implementation I have so many scenarios that I have to work. Since we have the license for the tool, do you think of any licensed video courses (besides official documentation and 10 courses on Red Gate website) for customers who bought the tool. If there are any that would be helpful. Below ae some of my scenarios I am going to work. 1)Same data masking in multiple tables with consistency 2)XML masking 3)Data Insertion Thank you, Arun / comments
Hi @PlantBasedSQL Thank you so much for the step by step explanation, it worked well and I've got the expected results.In my Implementation I have so many scenarios that I have to work. Since we ha...