Comments
Sort by recent activity
Hi Dave, Apologies for coming back to you so late, I have just come across this post! Its perfectly possible to change a PK and all associated FKs using Data Masker - you will need to use a Substitution Rule converted to a Synchronisation Manager rule to do this. You can read more about this process here: https://documentation.red-gate.com/dms6/data-masker-help/version-6-tech-tips/how-do-i-change-a-primary-key-value-and-all-associated-foreign-keys I understand that I'm possibly a bit too late with this answer, but hopefully, this helps if not, and if you have any other queries about Data Masker please do feel free to let us know! Thank you very much. / comments
Hi Dave,Apologies for coming back to you so late, I have just come across this post!Its perfectly possible to change a PK and all associated FKs using Data Masker - you will need to use a Substitut...
Hi @davedunckley just to follow up - were you able to resolve this issue at all? Thanks! / comments
Hi @davedunckley just to follow up - were you able to resolve this issue at all? Thanks!
Hi @victorrocha93 Apologies for coming back to you so late - were you ever able to get an answer to this question? I would be more than happy to go through how Data Masker can be adapted into your process if you're still looking for a solution! Thank you very much. / comments
Hi @victorrocha93 Apologies for coming back to you so late - were you ever able to get an answer to this question?I would be more than happy to go through how Data Masker can be adapted into your p...
Hi @bestrongself Thank you for your post - It is absolutely possible to monitor SQL Server on Azure - you can find full details on installing SQL Monitor here: https://documentation.red-gate.com/sm7/getting-started/installing and then full instructions on adding different servers to SQL Monitor here: https://documentation.red-gate.com/sm8/configuring-sql-monitor/adding-and-configuring-servers/adding-servers-to-monitor Please feel free to let me know if you need any further information! / comments
Hi @bestrongself Thank you for your post - It is absolutely possible to monitor SQL Server on Azure - you can find full details on installing SQL Monitor here: https://documentation.red-gate.com/sm...
Hi @caharkness thanks for your post! The Redgate support team can fix this issue for you by restoring activations to your serial - if you email your serial number to support@red-gate.com typically these requests are actioned in only a few hours! Let me know if you need any further information - thank you very much! / comments
Hi @caharkness thanks for your post!The Redgate support team can fix this issue for you by restoring activations to your serial - if you email your serial number to support@red-gate.com typically t...
Hi @eleightondick Thank you for the question! 1) The product IS available standalone although financially it does make the most sense to look at SQL Provision as a whole, the cloning aspect is particularly useful for creating said pre-production environments and auditing where we're putting data and how we're protecting it. 2) There is functionality within Data Masker to mask XML columns: https://documentation.red-gate.com/dms6/data-masker-help/masking-rules/about-xml-masker-rules 3) Unfortunately not - you can do find-replaces in text columns for single values (but this wouldn't be applicable in this instance where all the values are different SSNs) - assuming the column is freehand text there are multiple challenges associated with this such as false positives, different spacing styles, people putting numbers in with letters etc. so there are a couple of ways around it to try and keep the data realistic. If you would like to go through these in a bit more depth please feel free to send me a DM and I'll be happy to go through some with you. Thank you very much! / comments
Hi @eleightondick Thank you for the question!1) The product IS available standalone although financially it does make the most sense to look at SQL Provision as a whole, the cloning aspect is parti...
Hi @gcbaum_62 thank you for your comment, I'm more than happy to put you in touch with a member of the Redgate team who can help with this requirement, are you happy for me to pass your email address across to our US based team? Thank you very much! / comments
Hi @gcbaum_62 thank you for your comment, I'm more than happy to put you in touch with a member of the Redgate team who can help with this requirement, are you happy for me to pass your email addre...
Hi @StockportJambo thank you for your post! In these situations, it is much easier to get in contact with a representative here at our Cambridge HQ who will be able to go through the requirement with you and put together appropriate pricing, we are no strangers to working closely with academic institutions! If you PM me your email address I'd be more than happy to put the correct person in touch! Thank you very much! / comments
Hi @StockportJambo thank you for your post!In these situations, it is much easier to get in contact with a representative here at our Cambridge HQ who will be able to go through the requirement wit...
Hi @mikemalino thank you for your post! I have set up a similar test scenario using a local DB where I changed an NVARCHAR(100) to NVARCHAR(150) and used SQL Compare to carry out the comparison and deployment which generated an ALTER statement by default. Can I confirm which version of SQL Compare you're using and also that the "USE DROP and CREATE instead of ALTER" project setting is unticked? Thank you very much! / comments
Hi @mikemalino thank you for your post!I have set up a similar test scenario using a local DB where I changed an NVARCHAR(100) to NVARCHAR(150) and used SQL Compare to carry out the comparison and ...
Hi @kullboys thanks for your post! The Redgate support team can fix this issue for you by restoring activations to your serial - if you email your serial number to support@red-gate.com typically these requests are actioned in only a few hours! Let me know if you need any further information - thank you very much! / comments
Hi @kullboys thanks for your post!The Redgate support team can fix this issue for you by restoring activations to your serial - if you email your serial number to support@red-gate.com typically the...