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 @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...
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...