Activity overview
Latest activity by Arun72
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...
Data Masker from command line-PowerShell
Hello All,I am trying to run the masking from the command line and replicated the same that shown in the video from the official website. I also added the path for "DataMaskerCmdLine" in the system...
@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, @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...
SQL Data Catalog connectivity Issue
Hello,I have configured SQL Data Catalog in my PC and trying to connect to one of the Dev Server databases. Since we don't have an Instance(per DBA) I am trying to add Server in my Catalog tool und...
SQL Clone Image Creation
Hello,Is there a way that we can pull data from the production on scenario based (we can say subset) from a single database/multiple with Referential Integrity?I wanted to create an Image with subs...
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...
Insertion feature
Hi All,I'm trying to insert the data using "Insertion" rule in SQL Data Masker. I was able to insert the data into my new table. Is there any way that I can insert the data into a table which alre...