Comments
Sort by recent activity
Hey @giumaRE - quick question just to check, maybe a clone with that name doesn't already exist on that instance, but is there an already existing DB on that instance with the same name? Or any possibility of something similar? Thanks! / comments
Hey @giumaRE - quick question just to check, maybe a clone with that name doesn't already exist on that instance, but is there an already existing DB on that instance with the same name? Or any pos...
Hi @lnielsen - have you looked at the job failing alert in SQL Monitor? Example here: Job failing alert (red-gate.com) on the demo website / comments
Hi @lnielsen - have you looked at the job failing alert in SQL Monitor?Example here: Job failing alert (red-gate.com) on the demo website
@LisaM - if you go to the UNC path where the image is being stored, has the mounted VHDX been removed? It could be 1 of 3 scenarios in my experience of working with SQL Clone: 1) The Image was deleted but SQL Clone wasn't able to update the SQL Clone Config DB properly to show it has been deleted -> If this is the case you can possibly (very carefully) update the SQL Clone Config DB for that particular image to show it has been deleted (you should see from the pattern of other images in the images table what status to update it to) 2) SQL Clone was unable to delete the image from the fileshare so it is now stuck waiting for the deletion 3) Something else entirely :-) / comments
@LisaM - if you go to the UNC path where the image is being stored, has the mounted VHDX been removed?It could be 1 of 3 scenarios in my experience of working with SQL Clone:1) The Image was delete...
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...