Comments
Sort by recent activity
Hi @Fausto There are tables generated at run-time, the DMS Stats tables for Rules and for Tables - these tell you how the rules ran and how many rows/columns etc. on the various tables were masked. Unfortunately, these don't provide detail down to the column level like the report generator in the tools tab, but could be utilised and somehow pulled out to give a better overall idea of the masking in other tools, if that helps? Thank you very much - let me know if you have any other questions! / comments
Hi @Fausto There are tables generated at run-time, the DMS Stats tables for Rules and for Tables - these tell you how the rules ran and how many rows/columns etc. on the various tables were masked....
Good Morning @Fausto thank you for your post. You can generate something similar with Data Masker if you go to the Tools tab and hit "Rule Structure Report" If you generate a full structure report it should include a similar list to the one you're looking at creating. Let me know if this works and if you have any additional questions - happy to help! Thank you very much. / comments
Good Morning @Fausto thank you for your post.You can generate something similar with Data Masker if you go to the Tools tab and hit "Rule Structure Report"If you generate a full structure report it...
Hi @... thank you for your post. In SOME cases it is possible to see some of the tSQL that Data Masker is generating, but these are usually circumstances few and far between (i.e. if you go into the logs and look down as its running the rules you'll see some of the tSQL that was generated etc.) In my mind the only way to fully see everything Data Masker ran would be to put a trace on the DB, ensure there's no other activity on it and then run the rules, ending the trace when it finishes. My question would be why you need to be able to see this? Is there anything that you're expecting to be able to do with Data Masker that you're not sure how to do or that it currently cannot? Thank you very much. / comments
Hi @... thank you for your post.In SOME cases it is possible to see some of the tSQL that Data Masker is generating, but these are usually circumstances few and far between (i.e. if you go into the...
Thanks @AndrewH I will catch up with the development team and see if this is a bug and if they're able to generate a fix for you, or if we've just missed something and there's another way around it! / comments
Thanks @AndrewH I will catch up with the development team and see if this is a bug and if they're able to generate a fix for you, or if we've just missed something and there's another way around it!
Hi @AndrewH Thank you very much for your post - I can see that when I open the JSON masking rule I do indeed have access to this particular DataSet (see attached picture), are you able to share what you're seeing at all please? If you still can't see this have you tried downloading the newest release and updating just in case? Thank you very much. [image] / comments
Hi @AndrewH Thank you very much for your post - I can see that when I open the JSON masking rule I do indeed have access to this particular DataSet (see attached picture), are you able to share wha...
Oh I should also mention the SQL Packager Utility: https://documentation.red-gate.com/sqp8 that you can use to package up any scripts generated by SQL Change Automation if needs be [image] / comments
Oh I should also mention the SQL Packager Utility: https://documentation.red-gate.com/sqp8 that you can use to package up any scripts generated by SQL Change Automation if needs be
Hi @SJW thank you for your post, there are some great walkthroughs of using SQL Change Automation here: https://www.red-gate.com/hub/university/sql-change-automation-with-migrations to help get you started. There are a number of ways of using the tooling to achieve what you're looking for and I believe the most relevant pages in the Redgate docs to point you at for this would be regarding command line deployment here: https://documentation.red-gate.com/sca3/automating-database-changes/automated-deployment-with-sql-change-automation-core/command-line-deployment-msbuild or SQLCMD package deployment here: https://documentation.red-gate.com/sca3/automating-database-changes/automated-deployment-with-sql-change-automation-core/sqlcmd-package-deployment Though we would be advocates of the full CI/CD model that, although Dev shouldn't have access to Test and Staging etc. there's nothing stopping you from using the SQL Change Automation Plugins for various build and release tools such as Azure DevOps to carry out most of this work. You can read more about the model here if you aren't already aware of it: https://www.red-gate.com/solutions/need/automate Let me know if you have any questions about this, always happy to help! / comments
Hi @SJW thank you for your post, there are some great walkthroughs of using SQL Change Automation here: https://www.red-gate.com/hub/university/sql-change-automation-with-migrations to help get you...
Hi @JohnJack - you can find the documentation for the older version of SQL Prompt here: https://documentation.red-gate.com/sp4/requirements By the looks of it, the highest version of SSMS will be 2008r2. That being said, if you no longer have a supported license and you're interested in updating your SQL Prompt license to the newest version (v9) you would get a whole host of features such as SSMS v17 support, Static Code Analysis, more comprehensive team formatting etc. If you're interested in having a discussion around your licenses and what the most cost effective way is to upgrade them, please feel free to reach out to your account manager or to sales@red-gate.com and we'll be happy to help! Thank you very much. / comments
Hi @JohnJack - you can find the documentation for the older version of SQL Prompt here: https://documentation.red-gate.com/sp4/requirements By the looks of it, the highest version of SSMS will be 2...
Hi @arungk am I right in thinking this is a duplicate question to the other you asked? If so we can continue the thread on the other question in progress. Thank you very much. / comments
Hi @arungk am I right in thinking this is a duplicate question to the other you asked?If so we can continue the thread on the other question in progress.Thank you very much.
Thank you @arungk If you are having deadlocks between range splitter rules then potentially there must be some overlap between them or the ranges have not been specified correctly. Have you checked that the range splitter has been defined correctly and that the rules don't cross-over when it comes to the range values? Also if you would like me to take a further, more in-depth look at this, please feel free to send your .dmsmaskset Masking Set (which doesn't contain any sensitive data, it is just the XML config file) and, if possible, the logs from the deadlocking run, and I will investigate this further. My email is: chris.unwin@red-gate.com Thank you very much - have a great weekend. / comments
Thank you @arungk If you are having deadlocks between range splitter rules then potentially there must be some overlap between them or the ranges have not been specified correctly.Have you checked ...