Search
-
Re: Does anyone else's Community CLI not work?
Yes. I have inherited a codebase and the upgrade database script runs this. powershell flyway -outOfOrder="true" migrate -url=jdbc:postgresql://${host}:${port}/${database} -locations=filesystem:./${MIGRATION_FOLDER} -user=${user} ${passwordSection} When I ran this, I saw no debug statements at all. Just a silent end of the… -
DLM with Teamcity Build
Hi, I am trying to integrated redgate dlm automation with teamcity. When i tried to build the database package i am creating below error. [19:11:39][Step 1/2] C:\TeamCity\buildAgent\plugins\dlmautomation-teamcity-agent\DLMAutomationRunner [19:11:39][Step 1/2] .ps1 : Error running DLM Automation action: see build log for… -
SQL Backup failed with exit code 820: SQL error code: 3203
Discussion by DanielBritten · · Home› Discontinued and Previous Versions› SQL Backup Previous VersionsI have a weekly SQL backup job that fails about once a month. Does anyone have any ideas? 3/1/2008 3:05:27 AM: Backing up Freight_2006 (full database) to: 3/1/2008 3:05:27 AM: K:\Backups\Weekly\Freight_2006.sqb 3/1/2008 3:05:27 AM: BACKUP DATABASE [Freight_2006] TO DISK = 'K:\Backups\Weekly\<AUTO>.sqb' WITH NAME =… -
Static data - WHERE clause
Discussion by TimVervers · · Home› Discontinued and Previous Versions› SQL Source Control Previous VersionsHi, Is there a way to mark a table as static data but only when a certain column in that table is for example "1". Visual example: ID Name Domain 1 Test 0 2 Test 0 3 Test 1 I only want the rows with domain 1 as static data. Thanks, Tim -
Is If-Then-Else logic possible
Suppose I have two columns and I want column 2 to be based on the random value from column 1. For example, column 1 is Yes|No. I'd like column 2 to be 1 when column 1 = Yes and 0 when column 1 = No. Is this possible? I am new to regex expressions and tried to search online for examples, but what I found doesn't seem to… -
Backup timeouts
I am having some issues with backups getting the 1010 and 3201 errors on a couple of my servers, but cannot seem to get them to go away. The second or third backup attempts appear so far to always be successful. Not sure where I need to continue to resolve this appropriately. Thanks Jon Here is an example of error email… -
SCA is unreliabe
I get this error , randomly , now consistently RedGate.Versioning.Client.VsShell.Ssms.Models.Observable.UnhandledObserverException: A subscribed observable threw an unhandled exception: Object reference not set to an instance of an object. ---> System.NullReferenceException: Object reference not set to an instance of an… -
Parentheses lost aligment in case/when clauses
Hi. I'm trying to format a code as the sample bellow:select case 1 when 1 then 1 when 2 then (2) when 3 then 3 when 4 then 4 when 5 then 5 when 6 then 6 end; So have a complex statement that requires parenthesis to be coded. When SQL Prompts reformats my code, this happens:select case 1 when 1 then 1 when 2 then (2) when 3… -
Lost Teams Trial after taking v7.0 upgrade last week.
-
SCA doesn't create new schema in an existing database
So I'm trying to bring an existing production database under source control. I created a Visual Studio project and successfully created a baseline from the production database in my local environment. The db didn't already exist locally so was correctly created by SCA. When I try and release via Azure DevOps to our "Build"…
>5988 results