Comments
Sort by recent activity
Assuming you mean you can't remove the clone using the UI, I've previously resolved problems like this by deleting the clone's record from the appropriate table in SQLClone_Config database (noting that there is 'soft delete' trigger on the tables). / comments
Assuming you mean you can't remove the clone using the UI, I've previously resolved problems like this by deleting the clone's record from the appropriate table in SQLClone_Config database (noting ...
This is one of my biggest frustrations with the Redgate tools: something is different but we're not going to tell you what! I've spent many hours trying to figure out what is actually different and I've found that it is normally something obscure (permissions or, most recently, column ordering). Have you run SQL Compare with your database against the source/target state scripts in your release with the exact options used in the post-update schema check? / comments
This is one of my biggest frustrations with the Redgate tools: something is different but we're not going to tell you what! I've spent many hours trying to figure out what is actually different and...
Hi RedgateRoss, here's some Powershell I use to find the most recent image for any given database:
$allImages = Get-SqlCloneImage | Where-Object {$_.OriginDatabaseName -eq $database} $LatestImage = $allImages | Sort-Object -Property CreatedDate | Select-Object -Last 1
$latestImageName = $latestImage.Name Chris
/ comments
Hi RedgateRoss, here's some Powershell I use to find the most recent image for any given database:
$allImages = Get-SqlCloneImage | Where-Object {$_.OriginDatabaseName -eq $database}$LatestImage =...
Hi - happens with the two databases we create images from: ~220GB and ~ 560GB. I'm in touch with your support team now who are looking into things. / comments
Hi - happens with the two databases we create images from: ~220GB and ~ 560GB. I'm in touch with your support team now who are looking into things.
ErdoganOzkoca said:
Hi, could you please check if a database encryption software like BitLocker is enabled? When BitLocker is enabled fixed drive volumes becomes readonly and gives error while creating image. Please check SQL Clone documentation https://documentation.red-gate.com/clone3/faqs#FAQs-DoesSQLCloneworkwellwithdriveencryptionsoftwarelikeBitLocker?
Nothing like that installed and this is a temporary error. Like I said, re-running the image creation has always been successful. / comments
ErdoganOzkoca said:
Hi, could you please check if a database encryption software like BitLocker is enabled? When BitLocker is enabled fixed drive volumes becomes readonly and gives error whil...
We use Windows self-hosted agents: https://docs.microsoft.com/en-us/azure/devops/pipelines/agents/v2-windows?view=azdevops. Have you installed the two SQL Change Automation extensions from the marketplace - they're needed for the pipelines (unless you build your own bespoke ones using the Powershell cmdlets): https://marketplace.visualstudio.com/search?term=redgate&target=AzureDevOps&category=All%20categories&sortBy=Relevance / comments
We use Windows self-hosted agents: https://docs.microsoft.com/en-us/azure/devops/pipelines/agents/v2-windows?view=azdevops. Have you installed the two SQL Change Automation extensions from the mar...
Hi John - I'm doing this right now because we're migrating to Azure DevOps from TFS on premises so can assure you that it does work and is pretty straightforward! Local Dev database -> Azure DevOps repo using SQL Source Control -> Azure DevOps Build/Release pipelines using SQL Change Automation extensions -> local Test database. / comments
Hi John - I'm doing this right now because we're migrating to Azure DevOps from TFS on premises so can assure you that it does work and is pretty straightforward! Local Dev database -> Azure DevOps...
Commit the static data changes you want to deploy separately from any schema changes? / comments
Commit the static data changes you want to deploy separately from any schema changes?
I'm interested in the resolution to this too. I've been trying to commit changes from SQL Source Control to a GIT repo in both Azure DevOps and on premise TFS2013 with no success (I've previously been successful using GIT command line). I have no "Credentials.xml" file and, unlike in a previous answer on the forum, get no option to enter a PAT when pushing to my repo. Any help would be much appreciated as currently out of ideas of how to resolve! SQL Source Control v7.0.6.8775 in SSMS v17.4 / comments
I'm interested in the resolution to this too. I've been trying to commit changes from SQL Source Control to a GIT repo in both Azure DevOps and on premise TFS2013 with no success (I've previously b...
Are you using a filter file and is the same file being used when you commit objects to source control and during your build & release pipelines? From when I first set-up our TFS pipelines and a user was being dropped, I think the only way to exclude users/roles is via a filter rule. The option you mention will not exclude users, only their permissions. / comments
Are you using a filter file and is the same file being used when you commit objects to source control and during your build & release pipelines? From when I first set-up our TFS pipelines and a use...