Comments
Sort by recent activity
Thanks Simon - no problem, thanks for clarifying! It's a tough problem, in the past I've used SQL Clone to get round this because you can integrate SCA with it and it does builds on top of the cloned DB, which gets around the "deploying the full DB in the build problem" - if you have access to that, it could potentially help? Although I think if you're using SQL Source Control as the method for source controlling this wouldn't help. The other option is I believe asking the question "do we even need to do a full build?" - whilst there is obviously value to a full clean build, invalid objects and unfixable problems mean that it's really just a blocker to the rest of the process. Is there any reason why, instead of a build, you couldn't just zip up the files as part of the pipeline and pass the zip file along instead of the build artifact? Once pushed down the pipeline for release you can then just carry on as normal and pass it to the New-DatabaseReleaseArtifact cmdlet (Docs: https://documentation.red-gate.com/sca/reference/powershell-cmdlets/new-databasereleaseartifact) - I'm running off of my older knowledge here as it's been a while since I used SCA specifically but I think (and it looks like) it might accept a zip folder of the files from your GitHub repo instead of the NuGet specifically... I'm sure one of the tech folks from Redgate's side, or maybe their support team would be able to give an even better answer than me, but it might be something to explore initially if it helps you get started [image] / comments
Thanks Simon - no problem, thanks for clarifying! It's a tough problem, in the past I've used SQL Clone to get round this because you can integrate SCA with it and it does builds on top of the clon...
Hey @Simon501 just to clarify - do you mean the very first time you try to source control the DB? So you've connected to Dev as your development source and Test to take your baseline - and now the verify is failing because it's trying to build the Shadow Database from the baselines script? / comments
Hey @Simon501 just to clarify - do you mean the very first time you try to source control the DB? So you've connected to Dev as your development source and Test to take your baseline - and now the ...
Hey @Keith_DBA - someone from RG might be able to correct me, but I don't believe SSAS is supported in SQL Monitor - although there is a couple of UserVoice requests for this Monitor SSAS databases – SQL Monitor (uservoice.com) (this is the one most voted for that I could find) / comments
Hey @Keith_DBA - someone from RG might be able to correct me, but I don't believe SSAS is supported in SQL Monitor - although there is a couple of UserVoice requests for thisMonitor SSAS databases ...
@Miles if I'm honest I would log a ticket with Redgate support (support@red-gate.com) with a screenshot and some logs - that'll probably be your fastest way of getting some help to resolve imho That and double-double check the docs to make sure everything is configured: Setting up email notification - SQL Monitor 12 - Product Documentation (red-gate.com) Also the log files might hold some more info: Viewing component information and log files - SQL Monitor 12 - Product Documentation (red-gate.com) / comments
@Miles if I'm honest I would log a ticket with Redgate support (support@red-gate.com) with a screenshot and some logs - that'll probably be your fastest way of getting some help to resolve imhoThat...
@Miles if I'm honest I would log a ticket with Redgate support (support@red-gate.com) with a screenshot and some logs - that'll probably be your fastest way of getting some help to resolve imho That and double-double check the docs to make sure everything is configured: Setting up email notification - SQL Monitor 12 - Product Documentation (red-gate.com) Also the log files might hold some more info: Viewing component information and log files - SQL Monitor 12 - Product Documentation (red-gate.com) / comments
@Miles if I'm honest I would log a ticket with Redgate support (support@red-gate.com) with a screenshot and some logs - that'll probably be your fastest way of getting some help to resolve imhoThat...
@Gail just to clarify, the Pull Request is created and built successfully, and then is this merged back into a deployable maser/trunk branch? Is the PR supposed to be deployed itself to a Testing environment, or Prod? or do you have some other steps in there? Secondly when you say "Azure to house our instances" / "push from local to azure" are you talking specifically about Azure DevOps? and are you developing locally / on Azure VMs or against Azure SQL DBs / Azure MI? Also are you using SQL Change Automation in your Azure Pipeline for the Build Deploy steps or something else? Sorry for all the questions - I think it would take a bit more information about the process, build and deployment configuration and which exact components you're using before they could figure out where the break is in the process. / comments
@Gail just to clarify, the Pull Request is created and built successfully, and then is this merged back into a deployable maser/trunk branch? Is the PR supposed to be deployed itself to a Testing e...
@Terje you might need to use a Row-Internal Rule converted to a Sync Manager rule, then you can use SQL syntax to effectively have a replacement value clause of SUBSTRING(SSN, Parts 1 - x of SSN that you want to keep) + DMSPARAM1 where DMSPARAM1 is a randomly generated 4 digit number [image] / comments
@Terje you might need to use a Row-Internal Rule converted to a Sync Manager rule, then you can use SQL syntax to effectively have a replacement value clause of SUBSTRING(SSN, Parts 1 - x of SSN th...
Hi @yaserkat you'll have to check with sales@red-gate.com but from my knowledge I believe Redgate stopped selling the SDK a few years ago, even the old version. To do anything similar to what the SDK did - you'll need to look at something like Redgate Deploy which would help you get everything packaged up and deployed, or will give you the comparison technology you need to do ad-hoc comparisons and deployments. / comments
Hi @yaserkat you'll have to check with sales@red-gate.com but from my knowledge I believe Redgate stopped selling the SDK a few years ago, even the old version.To do anything similar to what the SD...
@mbolufe you will most likely need a Sync-Manager rule for this if there is no common join between the tables on the tables themselves. Data Masker will create the common table between them and sync the values across consistently so just convert your substitution rule to a sync manager instead of using the Table-to-Table sync itself [image] / comments
@mbolufe you will most likely need a Sync-Manager rule for this if there is no common join between the tables on the tables themselves.Data Masker will create the common table between them and sync...
@VmWare you should be able to convert a Row-Internal Rule to a Sync Manager rule which should allow you to mask the Primary Key value - just be aware you will likely need to ensure whatever is being masked in as the replacement values clause is almost guaranteed unique so that when the Sync manager tries to restore the constraint it doesn't violate the unique restriction. / comments
@VmWare you should be able to convert a Row-Internal Rule to a Sync Manager rule which should allow you to mask the Primary Key value - just be aware you will likely need to ensure whatever is bein...