Best Of
Re: Error Detect SQL Servers Initialization failure
Alex B's posting fixed my issue by removing the "MSCluster" namespace.

1 ·
Re: Does Flyway Support migrations to Redshift Serverless
Hi @JBravo
Thank you for letting me know.
The updated URL is here:
https://documentation.red-gate.com/fd/redshift-277579326.html
Thank you for letting me know.
The updated URL is here:
https://documentation.red-gate.com/fd/redshift-277579326.html

1 ·
Re: RFC - .Net 9 compatibility in Smart Assembly
Having not identified any major issues with .Net 9, we now consider it supported by Smart Assembly.

1 ·
Re: Is it possible to have SQL Prompt in Visual Studio Code
Here I am three and a half months later installing "Prettier" in VSCode to format SQL scripts that tabnine is helping me write. Wouldn't it be nice if SQL Prompt ran natively in VSCode and included a connection to AI? I've been writing SQL for almost 30 years but just because I can doesn't mean that I should. The next generation of tools will help veterans like me write better code faster because I don't have to deal with all the details. SQL Prompt did that for a while but it is falling behind now.

2 ·
Re: "Cannot Check for Updates" Error (SQL PROMPT 10.6.6.18829)
Hi @Fadi
Thanks for your post. I'm sorry to hear you're having issues with Check for updates.
Please can you make sure you have access to the Redgate endpoints for updates listed in the article below?
Bypassing firewall and licensing endpoints to whitelist
Thanks for your post. I'm sorry to hear you're having issues with Check for updates.
Please can you make sure you have access to the Redgate endpoints for updates listed in the article below?
Bypassing firewall and licensing endpoints to whitelist

2 ·
Re: Anyone else have suggestions not working in latest update of SQL Prompt?
Its been 1 year. Any progress from your team on the solutions to this?Ben_P said:The issue seems to be due to SSMS 19.3 using MDS 3.1.5 whilst SQL Prompt uses 3.1.1. Whilst the team work on a solution for this, it is recommended to use an earlier version of SSMS, such as 19.2 or 18.12.1. Users have also reported that downgrading SQL Prompt to 10.4.4 has worked for them:
https://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_10.14.4.4865.exe

1 ·
Re: Compare two SQL databases schema changes those are from two different servers, using DevOps
Just to add to what emmar00 said, Flyway is comprehensive DevOps software that covers generation of deployment scripts, integrates into pipelines, and also handles source control. You may want to take a look at that to see if that fits your needs as well.

1 ·
Re: Extension not working again
Hi All,
There has been a fix released in SQL Prompt 10.16.5.15563 As part of this release the ADS timebomb has been extended.
In light of Microsoft announcement yesterday, The extension is for 3 months only.
Update the ADS version to 0.2.16. (attached)
I sympathise with your frustrations, I want to reassure you that we are in constant communication with the development team to try to highlight the volume of concerns we have on this matter.
There has been a fix released in SQL Prompt 10.16.5.15563 As part of this release the ADS timebomb has been extended.
In light of Microsoft announcement yesterday, The extension is for 3 months only.
Update the ADS version to 0.2.16. (attached)
I sympathise with your frustrations, I want to reassure you that we are in constant communication with the development team to try to highlight the volume of concerns we have on this matter.

2 ·
Re: Extension not working again
Thanks @Robyn, we understand that you're the messenger here. I'm certain you're taking our concerns back to the people who should hear them. I think the elements that are most critical that they hear are:Robyn said:There is not. We have chased for an ETA today, but currently have been given no timeframe.
1. The way the timebomb is implemented is horrible. It's massively disruptive and there's no warning of up-coming cessation of the feature - not even a countdown or expiration date. Indeed, when the user discovers it, it's because the program just errors out causing us to try to troubleshoot it, only then to discover that the extension expired. This leads to the second issue:
2. Updates do not appear to be timely. If this product is a loss-leader designed to showcase Redgate's benefit to developers and promote sales of much more powerful and feature-packed offers, failing to provide timely releases to those products will have the opposite result. It will cause users who have their work disrupted right in the middle of something important go hunting for an alternative, potentially finding something more to their liking; potentially sticking with it.

1 ·