Activity overview
Latest activity by chris_godfree
We've been battling with Partition Schemes / Functions and how to deal with them for some time! We've seen this error at times (most recently when a development database was moved to a new server and connected back to the same Git repo!) and come across other issues when deploying them too. We've tried excluding them with the relevant ignore option and excluding them with a filter but always come up against a problem at some point What we're currently doing (just started yesterday so not sure it addresses all our issues yet):
create a new Git repo;
add a Pre-Deployment script with create statements (within existence checks) for all Partition Schemes / Functions;
add Partition Schemes / Functions and tables which use them to the Git repo;
specifically exclude Partition Schemes / Functions from our Azure DevOps Build and Releases using the ifg SQL Compare option.
This means the Partition Schemes / Functions will be created once on every database we deploy to but also covers the issue we see of that "not found" message. / comments
We've been battling with Partition Schemes / Functions and how to deal with them for some time! We've seen this error at times (most recently when a development database was moved to a new server a...
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 - 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.
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 =...
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...
Image creation error
We've just migrated our SQL Clone installation (v3.1.1.16103) to a new server and images to a new drive but we've started to get the error message below every couple of days - running the image cre...
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?
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...