Activity overview
Latest activity by Christian Perez
Hi John, Thanks for reaching out to Redgate Support and sorry to hear you are having a little trouble with your SQL Prompt installation. Would you be able to share a screenshot of what SQL Prompt is ‘bringing up’ for authentication? What kind of authentication method are you utilizing when you authenticate against your server instance? Entra MFA? SQL Server Authenticaiton? Windows Authentication? Hopefully with a little clarification we can figure out exactly what is preventing you from using Prompt. / comments
Official comment
Hi John,Thanks for reaching out to Redgate Support and sorry to hear you are having a little trouble with your SQL Prompt installation. Would you be able to share a screenshot of what SQL Prompt is...
Hi Ivailo, After further investigation the developers have marked this particular issue as Won't fix as they have prioritized other development projects/features. Apologies as I am sure this was not what you expected to hear. Best Regards, Christian Perez / comments
Official comment
Hi Ivailo, After further investigation the developers have marked this particular issue as Won't fix as they have prioritized other development projects/features. Apologies as I am sure this was no...
Hi Terry, Thanks for reaching out to Redgate Support, sorry to hear you are having a little trouble with your Schema Compare for Oracle Behavior, I have a few pathfinder questions to try and figure out what we need to do here. Is the behavior you are reporting occurring when you generate the Deployment script for your comparison? Do you notice anything when reviewing the Comparison pane for the PERFORMANCE schema? I am reviewing options in the application and one option besides ignoring double quotes would be the option “ExcludeSchemaNames”, which if nothing else would force the generated code to be consistent. / comments
Official comment
Hi Terry, Thanks for reaching out to Redgate Support, sorry to hear you are having a little trouble with your Schema Compare for Oracle Behavior, I have a few pathfinder questions to try and figure...
Hello Jānis, Hope you are doing well today, thanks for reaching out to Redgate Support regarding your Prompt formatting question. I took the SQL examples you provided and I attempted to format them and get the TO ReadRole to right-align, but I was also unsuccessful, so I am leaning towards agreeing with you that this is not possible at the moment. In which case the best avenue for you would be to create an entry on Prompts User Voice page to see if we could get this implemented in a future version of Prompt. Topics created on our User Voice forum are voted on by other Prompt/Redgate Users and utilized to determine what features to add to our products. Here is the link: https://redgate.uservoice.com/forums/94413-sql-prompt Let me know if you have any other comments or concerns. / comments
Official comment
Hello Jānis,Hope you are doing well today, thanks for reaching out to Redgate Support regarding your Prompt formatting question. I took the SQL examples you provided and I attempted to format them ...
Hi Jon, Thanks for reaching out to Redgate Support regarding your SQL Prompt 11 inquiry. In this case, since you already have the old SQLHistory file, you would need to navigate to your C:\Users\<YOURUSER>\AppData\Local\Red Gate\SQL Prompt 11 directory and replace the existing SqlHistory database file with the file from the old PC. That should integrate your old SQL History into the new Prompt. / comments
Official comment
Hi Jon,Thanks for reaching out to Redgate Support regarding your SQL Prompt 11 inquiry. In this case, since you already have the old SQLHistory file, you would need to navigate to your C:\Users\<YO...
Hi Jason, Checking in to see if you were able to update to the current version? / comments
Hi Jason, Checking in to see if you were able to update to the current version?
Hi Christine, Hope you are doing well today, sorry to hear you are having a little trouble with your SQL Data Compare install. Can we start with confirming that you are able to connect to this database instance using SSMS + Windows Authentication outside of Data Compare? If that works without issue, could you share with me the full error output that you are getting in the screenshot you shared with us? / comments
Official comment
Hi Christine, Hope you are doing well today, sorry to hear you are having a little trouble with your SQL Data Compare install. Can we start with confirming that you are able to connect to this data...
Hi Dirk, Hope you are doing well today, sorry to hear you are having a little trouble with your SQL Prompt installation, if you click on SQL Prompt > Help > Locate log files, could I trouble you to attach those logs here for review? I should be able to determine what we need to focus on next with those. That being said, there are some known issues with suggestions in version 11 of prompt that are still being worked on by the developers, so I would also ask what kind of database are you attempting to connect to, is this an Azure Synapse Database or something else? / comments
Official comment
Hi Dirk, Hope you are doing well today, sorry to hear you are having a little trouble with your SQL Prompt installation, if you click on SQL Prompt > Help > Locate log files, could I trouble you to...
Hi Bryan, Thanks for reaching out to Redgate Support regarding your Source Control issues. I was able to discuss this a bit further with the developers and they have concluded that this does appear to be the newly expected behavior from Source Control in SSMS 21. While the behavior you were seeing was indeed not nominal when comparing to older versions of Source Control, with SSMS 21, the initial loading behavior has changed. As a result, the SOC page does not auto load when SSMS 21 starts. This affects the initialization of certain events responsible for updating icons. Now (SSMSv21 onwards), these events get triggered whenever the SOC page is opened manually or the SOC button is clicked. Workaround options for you include the following. (Either of these steps will trigger the event and then the connected database will be identified as expected)
In SSMS 21, connect to DB server then open(Click on) SOC tab and Refresh the DB server.
In SSMS 21, connect to DB server then open(Click on) SOC tab, Disconnect, and Reconnect the DB server.Cancel the connection dialog when SSMS 21 opens, open the SOC page first, and then connect to the desired DB server.
Let me know if you have any follow up questions or concerns. / comments
Official comment
Hi Bryan, Thanks for reaching out to Redgate Support regarding your Source Control issues. I was able to discuss this a bit further with the developers and they have concluded that this does appear...
Hi Justin, Thanks for following up, you will need to update to the latest version of Prompt since you are using Entra MFA, there was a fix put out in that version for Synapse Dedicated Pools and Entra MFA authentication. Keep in mind you will be prompted to accept permissions when you initially connect after updating Prompt that you will need to do, this may require an admin to approve. You can find the download link here: https://download.red-gate.com/checkforupdates/SQLPrompt/ / comments
Hi Justin, Thanks for following up, you will need to update to the latest version of Prompt since you are using Entra MFA, there was a fix put out in that version for Synapse Dedicated Pools and En...