Search
-
Handling flyway migration failure
We have Flyway integrated to Bitbucket pipeline to deploy sql files in Snowflake database. It works like a breeze for best case scenario. When in bad scenarios, let's say there are 5 files added to code repository to be deployed, during migration if first two in the sequence goes through fine and the third has a syntax… -
Re: Visual Studio Extension vs SMSS add-in?
Hi @DiCaFe 1) Yes, you can use the same project in SSMS and the VS extension interchangeably, only difference is you have more control over the configuration directly in VS For core difference, please see the documentation here: https://documentation.red-gate.com/sca/developing-databases 2) We support both extensions… -
An unexpected null value has been found while running postprocessing operations on the script databa
I am contacting Redgate support. An unexpected null value has been found while running postprocessing operations on the script database. Please ensure the script database is consistent. If the problem persists, please contact Redgate support. at… -
bug：Case and when become a word.
select round(case when 1 = 1 then 1 else 0 end,4); Use the new formatting tool： select round( casewhen1= 1 then 1 else 0 end, 4 ); Case and when become a word. -
Generic "Scripts Folder Command" error when getting latest
I am receiving the following error when attempting to get latest on 1 of 5 databases. All other databases correctly return results. Below is the full error message I'm receiving. Scripts Folder Command at RedGate.SQLDataCompare.Engine.ComparisonSession.GetTableReaders(ITableReader& reader1, ITableReader& reader2,… -
SQL Data Generator, Datatype: hierarchyid
We are testing SQL Data Generator. we have a table with a hierarchy ID column://1// 1/1 // 1/1/1 // 1/1/2 // 2 // 2/1 /etc. With the data generator we can generate hierarchyid data without problems: / 1002/16262/19222/14780 // 10021/14301/8796/8797 // 10036/18117/24409/28027 /etc. But the generated values do not represent… -
Incrementing, from 1, based on another column
Hi, I have a table which simplified is a sales orders lines table, with two columns, a reference to the sales order (this is a FK) and an order line. The order line column should increment from 1 to x but be unique to that sales order ID. For example: SalesOrderID OrderLine 1 1 1 2 1 3 2 1 2 2 3 1 And so on. Currently the… -
Source Control Data: Removing grouping option
Hi, it's possible to remove grouping option in files export option ? It's really hard to make some code review when i add a new row and this row go on top of the file and at next commit my first row after go at his place in the middle First commit INSERT INTO [dbo].[GroupFunction] ([GroupId], [FunctionId]) VALUES (1,… -
Re: Setting are not saved
Yes. I found 1 duplicate GUID. I fixed it, and now it works fine.Thank you! Note. The snippets folder is a network-shared folder. var dup = Directory.GetFiles(dirPath) .Select(f => f.Substring(f.IndexOf('-') + 1)) .GroupBy(f => f) .Where(g => g.Count() > 1) .Select(f => f.Key) .ToList(); -
Connecting with Active Directory Password Authentication
Hi! Setup* Microsoft SQL server in Azure (V12) * SQL Server 2016 Management Studio 13.0.15000.23 * Redgate SQL Prompt 7.2.4.291 We are using Active Directory Password Authentication to connect to our databaseinstance. However, when SQL Prompt is loading I get the following log (Verbose logging on): 27 Jun 2016 10:56:05,693…
>5978 results
