Comments
Sort by recent activity
@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 ...
@RichardMGreen I think the easiest way around it (without using Data Masker) is to copy or restore a backup of the DB first using DBATools or other similar method via PowerShell, then run the modification scripts, then create the Image from that copy of the DB. This could at least have the unintended benefit of ensuring all transactions were completed before creating the image meaning they won't be replayed against the clones... / comments
@RichardMGreen I think the easiest way around it (without using Data Masker) is to copy or restore a backup of the DB first using DBATools or other similar method via PowerShell, then run the modif...
@RichardMGreen Q1 - are you creating the image from a backup file or from a live DB copy and Q2 - are you also using Data Masker for any obfuscation of the Image data? / comments
@RichardMGreen Q1 - are you creating the image from a backup file or from a live DB copy and Q2 - are you also using Data Masker for any obfuscation of the Image data?
Hey kr_DBA I'm pretty sure it should all be fine, so long as (just like on prem) SQL clone has all the network connectivity, ports open, credentials etc. Etc. I have seen SQL Clone in use on AWS and Azure Vms before, so I don't see why GCP would be any different. The documentation site (documentation.red-gate.com) has a fair architecture diagram and networking/permissions documents so as long as you stick to that you're good 👍 Hope you get on ok! / comments
Hey kr_DBA I'm pretty sure it should all be fine, so long as (just like on prem) SQL clone has all the network connectivity, ports open, credentials etc. Etc. I have seen SQL Clone in use on AWS an...