Comments
Sort by recent activity
Hi @vinay11 can you not simply edit the masking set and change the dataset that is being used for the Email column to the random emails dataset instead? / comments
Hi @vinay11 can you not simply edit the masking set and change the dataset that is being used for the Email column to the random emails dataset instead?
@vinay11 if you're masking Primary Keys then you'll be using a Sync Manager rule - if you're using a Sync Manager rule there should be rule within that group which deletes the temporary table containing the mappings of PK values to new masked values - if you disable this rule as part of the sync manager then it will not delete this table and you'll preserve the mappings which you can use to restore the values should you need. Obviously, this is less than ideal because you're leaving a way to reidentify the values after masking but you could manually drop the table once you're satisfied. / comments
@vinay11 if you're masking Primary Keys then you'll be using a Sync Manager rule - if you're using a Sync Manager rule there should be rule within that group which deletes the temporary table conta...
Hi @vinay11 there is no rollback in Data Masker because it is static masking, and wrapping all of the updates into transactions would not be practical for the log files (especially) You can of course just trigger the masking again though and it will just re-go over the rows it previously ran on. In what scenario do you think you will need a rollback? / comments
Hi @vinay11 there is no rollback in Data Masker because it is static masking, and wrapping all of the updates into transactions would not be practical for the log files (especially)You can of cours...
@GregTrevellick I would maybe look at the SQL Clone Config DB in the back end - the structure of the tables is pretty easy to understand so you could query them to find out what's attached to the image at that level, and then if it's a phantom connection that just hasn't been updated in the back end you could do that yourself and it should free the image up for deletion! / comments
@GregTrevellick I would maybe look at the SQL Clone Config DB in the back end - the structure of the tables is pretty easy to understand so you could query them to find out what's attached to the i...
Morning @pete29 I think what you're looking for is this: About Command Line Automation - Data Masker - Product Documentation (red-gate.com) There's also a (now slightly old) video on the university for it: Running Data Masker from the command line - Advanced Operations with Data Masker for SQL Server - Redgate University (red-gate.com) You can also run it with SQL Clone as part of SQL Provision for a single holistic way to refresh non-prod environments overnight: SQL Provision: Accelerate the delivery of database environments for DevOps teams (red-gate.com) Let me know if this helps! Cheers! / comments
Morning @pete29 I think what you're looking for is this: About Command Line Automation - Data Masker - Product Documentation (red-gate.com)There's also a (now slightly old) video on the university ...
@SR123 you should be able to specify the name of the output file when creating the NuGet package from the SQL Change Automation Build. You should then be able to pass in TFS / Azure DevOps variables or project variables into the naming. Pipelines variables: Define variables - Azure Pipelines | Microsoft Docs and pre-defined environment variables: Predefined variables - Azure Pipelines | Microsoft Docs / comments
@SR123 you should be able to specify the name of the output file when creating the NuGet package from the SQL Change Automation Build.You should then be able to pass in TFS / Azure DevOps variables...
@devi_sree I think you'd be better off forgetting the join and just using a synchronisation manager for this. Create a substitution rule on acctnum1 for however you want it masked, then in the change managers tab convert it to a sync manager. Then add the acctnum2 column as a target for the manager. It will create a distinct list of the acctnums in both columns, map it to a new masked randomized value and then mask this back in maintaining the referential integrity. There's a good example on RG University here: Masking Primary and Foreign Keys - Advanced Operations with Data Masker for SQL Server - Redgate University (red-gate.com) Just ignore that the video is targeted towards PK/FK relationships - it will still have the outcome you want. Let me know how you get on! / comments
@devi_sree I think you'd be better off forgetting the join and just using a synchronisation manager for this.Create a substitution rule on acctnum1 for however you want it masked, then in the chang...
@devi_sree I'm not sure I fully understand - are you able to provide an example with some example data perhaps? Like an ideal before and after so I can think about it a bit more and suggest a better example. / comments
@devi_sree I'm not sure I fully understand - are you able to provide an example with some example data perhaps? Like an ideal before and after so I can think about it a bit more and suggest a bette...
@ITBobbyP85 a thought on this - in general, objects on an Azure SQL Database and objects that exist on a SQL Server Database residing on a VM are, in many cases, exactly the same. Maybe with some slight syntax differences, but they're fundamentally database level objects (Tables, sprocs etc.) Therefore, they are considered in the same way by technologies such as SQL Source Control and Redgate Deploy and are equally fine to put into source control. I would recommend reaching out to the Redgate team, possibly your Redgate account manager so that you can have a better conversation about this as their Solution Engineers are all too familiar with both approaches. A lot of the video you'll see on the Redgate University site and YouTube etc. are actually using VM based SQL Server Databases anyway (apart from the ones that explicitly call out they're using PaaS alternatives or different RDBMS') / comments
@ITBobbyP85 a thought on this - in general, objects on an Azure SQL Database and objects that exist on a SQL Server Database residing on a VM are, in many cases, exactly the same. Maybe with some s...
Hey @pete29 - you should be able to do this if you double click the controller (usually 00-001) at the top of the masking set and change the DB connection and schema (if necessary) You will need to refresh the connection too, to make sure there are no major differences between the copies, although if the schema is the same you should be fine (although there may be different indexes at least which will need to be refreshed) - example on doing this here: https://www.red-gate.com/hub/university/courses/data-masker/advanced-operations-with-data-masker/advanced-operations-with-data-masker/refreshing-a-masking-set-controller Let me know if this helps! Thanks! / comments
Hey @pete29 - you should be able to do this if you double click the controller (usually 00-001) at the top of the masking set and change the DB connection and schema (if necessary)You will need to ...