Search
-
schema validation failed on create schema
Hi, I get following error when trying to build a package: I have 2 schema declarations: CREATE SCHEMA [Internal] AUTHORIZATION [dbo] GO CREATE SCHEMA [Util] AUTHORIZATION [dbo] GO I'm executing below command (without the masking): sqlci.ps1 -Verbose Build -scriptsFolder *** -packageId myDB-packageVersion 0.4-master… -
Lost Teams Trial after taking v7.0 upgrade last week.
-
THROW
Hi Redgate Team! SQL Prompt will format the following statement BEGIN TRY RAISERROR('test', 16, 1);END TRYBEGIN CATCH SELECT 1 THROWEND CATCH; like this BEGIN TRY RAISERROR('test', 16, 1);END TRYBEGIN CATCH SELECT 1 THROW;END CATCH; Which is wrong - instead it should be formatted like BEGIN TRY RAISERROR('test', 16, 1);END… -
SQL Prompt 7.5.0.912 - IF ELSE formatting not working as advertised
After upgrading to version 7.5.0.912, and typing the following into a query window: IF 1 =1 PRINT 'HELLO' ELSE IF 2=1 PRINT 'Good Bye' This is what I got after doing the Format: IF 1 = 1 PRINT 'HELLO'; ELSE IF 2 = 1 PRINT 'Good Bye'; I was expecting the ELSE IF to be on the same line. I did a reset to the default… -
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… -
Offline Schema-Model Issues
This issue just crept up today and appears to have started happening after the latest update. Message = Could not synchronize Offline Schema Model: Index was out of range. Must be non-negative and less than the size of the collection.Parameter name: index.Data = System.Collections.ListDictionaryInternalInnerException =… -
7.3.0.564 - Formatting Styles - CASE THEN expression
-
Re: Flyway cannot find AWS Credentials Chain
Yup. When we run aws configure, it creates a profile exactly like that, with a bit more information. We ran a code snippet to make sure our AWS SDK configuration was correct. import com.amazonaws.regions.AwsProfileRegionProvider; public class Scratch { public static void main(String[] args) { System.out.println(new… -
DLM Build Error
Hello, I am using the Team City DLM build plugin to create a build script. It seems there is some errors with the change script that the tool is trying to publish to the temp database. The error is: [16:03:03][Step 1/2] WARNING: The error 'Incorrect syntax near '('.' occurred when executing the following SQL:… -
Copying data in the same DB
>5978 results