Comments
Sort by recent activity
Hi @Sofoklis thank you for your question. When you create a correlated User Defined Data Set, Data Masker assumes this is varchar data, because most people use the number related data sets to generate house numbers etc. and then their own or the pre-set data sets to mask the street name. If this is an acceptable workflow for you then I would suggest that as it will be faster to mask the two together in such a way. If however you NEED the values to be correlated then my best suggestion would be: - Identify another column in the table you're going to be masking in this example let's say Address2 - Mask the Street Names and Address2 with your udefc set in a substitution rule - Use a row-internal sync rule and define it as a conversion from Address2 to number and target the Street Number column (the benefit to row-internal sync is you can use t-sql) - Then mask Address2 in the normal way The end result of this would be correct, it just requires an intermediate step to get there. I hope this is an ok workflow for you? Let me know if you have any thoughts! Thank you very much. / comments
Hi @Sofoklis thank you for your question.When you create a correlated User Defined Data Set, Data Masker assumes this is varchar data, because most people use the number related data sets to genera...
Thank you @Sofoklis That does sound like very unexpected behaviour - if you forward me your masking set (chris.unwin@red-gate.com) I'm more than happy to take a look for you. 1 caveat and 1 side note: - The masking set itself is only configuration, no sensitive data will be transmitted with it - I'm on a customer site this week so will have to look at it in the gaps i have and will do my best to get to it Thank you very much! / comments
Thank you @Sofoklis That does sound like very unexpected behaviour - if you forward me your masking set (chris.unwin@red-gate.com) I'm more than happy to take a look for you.1 caveat and 1 side not...
Hi @GeekSquared Thank you for your post! Just to confirm, are you trying to use the "Postcodes, UK" DataSet or the "Postcodes + Town + Country, UK" correlated DataSet for masking all 3 columns? Also, what data type are the latitude and longitude columns in your Database? Thank you very much! / comments
Hi @GeekSquared Thank you for your post!Just to confirm, are you trying to use the "Postcodes, UK" DataSet or the "Postcodes + Town + Country, UK" correlated DataSet for masking all 3 columns? Also...
Hi @... thank you for your post!
What you need to do is email your serial key through to support@red-gate.com with your serial key and our support team will be able to reset an activation for you so you can get back up and running - these requests are actioned asap so you shouldn't be waiting very long!
Let me know if you have any other problems - thank you very much! / comments
Hi @... thank you for your post!
What you need to do is email your serial key through to support@red-gate.com with your serial key and our support team will be able to reset an activation for you s...
Hi @... thank you for your question!
You can download the SQL Prompt executable from the Redgate website and port this across to the siloed machine and the trial should start automatically. If this does not happen it will offer you the opportunity to "Activate Offline".
If this is the case you will have to obtain a trial key (which you can get by emailing sales@red-gate.com) and then follow the manual activation steps mentioned here: https://documentation.red-gate.com/xx/licensing/activating which should then get everything up and running for you!
Let me know if you have any further problems with this! Thank you very much. / comments
Hi @... thank you for your question!
You can download the SQL Prompt executable from the Redgate website and port this across to the siloed machine and the trial should start automatically. If this...
Hi, @ramyers thank you for your question!
I've forwarded your question to a member of our team so that they can get in touch and answer any and all questions about upgrading your licenses.
Let us know if you have any other questions or if we can help out at all! Thank you very much. / comments
Hi, @ramyers thank you for your question!
I've forwarded your question to a member of our team so that they can get in touch and answer any and all questions about upgrading your licenses.
Let us k...
Hi @crossi thank you for your question!
The SQL Toolbelt is licensed per user using the tools and comes with a 1-server license for both SQL Monitor and SQL Backup Pro per license for you to use.
I'm happy to ask a member of our team to reach out and go through the use-case you have and how Redgate can help - would you like me to arrange this? / comments
Hi @crossi thank you for your question!
The SQL Toolbelt is licensed per user using the tools and comes with a 1-server license for both SQL Monitor and SQL Backup Pro per license for you to use.
I...
Hi @... Thank you for your question!
There could have been some issues communicating with the Redgate licensing server at some point which has led to this issue, apologise that you're experiencing this.
If you send an email to support@red-gate.com with your license key for the profiler and a screenshot of the message you're seeing (if available) then a member of our helpful support team will be on hand to help get this fixed ASAP!
Let me know if there's anything else we can do to help! / comments
Hi @... Thank you for your question!
There could have been some issues communicating with the Redgate licensing server at some point which has led to this issue, apologise that you're experiencing ...
Hi @Matt_M - the way the tool is licensed means that each SQL Clone Server needs to have its own license key (see Redgate EULA). That being said, you could theoretically install the 2nd SQL Clone Server separately and each time you want to test major upgrades to the tool you could speak with Redgate support or your account manager who I'm sure would be more than happy to provide a trial extension key so that you can use the newest version before updating the main Clone server.
Does that sound like a potential solution? Let me know your thoughts!
Thank you very much. / comments
Hi @Matt_M - the way the tool is licensed means that each SQL Clone Server needs to have its own license key (see Redgate EULA). That being said, you could theoretically install the 2nd SQL Clone S...
Hi @... thank you for your question!
Redgate compatibility with SSMS depends on the state of the license key, and not on the version of SSMS it was originally installed on. If you have a valid support and upgrades contract and you download the most recent version of SQL Prompt (version 9) then this should be absolutely fine working in SSMS 2017.
If you have any issues with this though please contact the Redgate Support team (support@red-gate.com) who will help you get back up and running asap!
Let me know how you get on! Thank you very much. / comments
Hi @... thank you for your question!
Redgate compatibility with SSMS depends on the state of the license key, and not on the version of SSMS it was originally installed on. If you have a valid supp...