How can we help you today? How can we help you today?
RickyR
Hi, Thanks for your inquiry. 1. How do I only mask/obfuscate the columns I need, not the whole table? Unfortunately, the only option for masking/obfuscation is: https://documentation.red-gate.com/disp ... ata+source 2. Can I run a command line prompt with a CSV file or other formatted file that has the table and columns I need to mask, have the program load, mask the data, then do the insert into the new database? Here is a reference to the command line documentation for SQL Data Generator 3: https://documentation.red-gate.com/disp ... ine+syntax Unfortunately, there is not a way to mask/obfuscate via command line. With regards to using a CSV file with SQL Data Generator, please see the following details: The creation of the CSV file occurs outside of SQL Data Generator, therefore SQL Data Generator cannot guarantee that each value for the CSV file is unique. So when generating a CSV file to populate a column, where the column is used to establish an index, SQL Data Generator prevents you from selecting a CSV file as a generator. The question you may now ask, why can I use a CSV file as a generator source for the complete table and just not for a single column established with a unique index? When using a CSV as a generator for a table, there are additional options, for example "when data is invalid:" option whose default setting is to 'Skip row', 'Specify number of rows by' and deletion of existing data from the table before generation. Sorry for the bad news! Please let me know if you have further questions, and have a great Wednesday! Rick / comments
Hi, Thanks for your inquiry. 1. How do I only mask/obfuscate the columns I need, not the whole table? Unfortunately, the only option for masking/obfuscation is:https://documentation.red-gate.com/di...
0 votes
Thanks for your patience with this issue. I have received an update that this issue should be resolved in the released 5.0.10 version of SQL Monitor. You can download it from here: https://www.red-gate.com/dynamic/produc ... /download# / comments
Thanks for your patience with this issue. I have received an update that this issue should be resolved in the released 5.0.10 version of SQL Monitor. You can download it from here:https://www.red-g...
0 votes
Hi Our Development team is aware of this situation, and they are actively working towards a resolve for it. Unfortunately we do not have an ETA for a fix as of yet, but, again, they are actively working on a resolution. Thanks Rick / comments
Hi Our Development team is aware of this situation, and they are actively working towards a resolve for it. Unfortunately we do not have an ETA for a fix as of yet, but, again, they are actively wo...
0 votes
Hi Phil, Thanks for your inquiry and sorry to hear about your issue with SQL Backup. I will go ahead and reach out to you via the case, as it will require more back and forth to resolve. Thanks! Rick / comments
Hi Phil, Thanks for your inquiry and sorry to hear about your issue with SQL Backup. I will go ahead and reach out to you via the case, as it will require more back and forth to resolve. Thanks! Rick
0 votes
Hi, Thanks for your inquiry. We have opened a case for you, and will be contacting you through this case, as it will require more time to diagnose your issue. Speak to you through the case, and have a great weekend! Rick / comments
Hi, Thanks for your inquiry. We have opened a case for you, and will be contacting you through this case, as it will require more time to diagnose your issue. Speak to you through the case, and hav...
0 votes