Comments
Sort by recent activity
Apologies Mark, You are certainly correct on the Visual Studio version mismatch! You should be compatible on version 2022 of VS as you mentioned, in which case, I would like to investigate further the Prompt Settings being used in Visual Studio. Could you confirm a couple of pathfinder items?
Are you missing suggestions for all Databases in Visual Studio or an environment in particular
Could you please include your SQL Prompt logs from Visual Studio to this post
Lastly, I am including a screenshot of how you can export your Prompt settings in Visual Studio, please export your settings file and I can then load it locally for testing.[image]
Thanks for the assistance with the above and apologies for the Version mismatch. / comments
Apologies Mark,You are certainly correct on the Visual Studio version mismatch! You should be compatible on version 2022 of VS as you mentioned, in which case, I would like to investigate further t...
Good Morning Mark Loew, Thanks for reaching out to Redgate Software for your Prompt concern. I suspect you may be seeing issues as a result of the version of Visual Studio that you are utilizing, version 10.14.13.8134 of Prompt does not appear to be supported in version 17.9.0 of Visual Studio as Visual Studio 2017 has been deprecated by Redgate. You can find more information on this being End of Support on the following page: https://documentation.red-gate.com/sp/getting-started/requirements/end-of-support-for-visual-studio-2015-and-2017 That being said, I would recommend that you try either: A. Downgrade SQL Prompt to a version older than v10.9 which should still be compatible with VS 2017 B. Upgrade Visual Studio to version 2019 or 2022 to make it compatible with Prompt. (This will also involve you reinstalling Prompt to get it to appear inside of Visual Studio as a tool) Cheers, Christian Perez Product Support Engineer / comments
Good Morning Mark Loew, Thanks for reaching out to Redgate Software for your Prompt concern. I suspect you may be seeing issues as a result of the version of Visual Studio that you are utilizing, v...
Apologies on the delay, I checked with my colleagues on this today to be sure and you are welcome to try, but we are not aware of a way to pass the RG_License programatically using the EXE file, however we have not tested this so if you do get this working, please let us know and I can get it documented. Best, Christian Perez / comments
Apologies on the delay,I checked with my colleagues on this today to be sure and you are welcome to try, but we are not aware of a way to pass the RG_License programatically using the EXE file, how...
Good Day dontflyway, Thanks for reaching out to Redgate Support regarding your questions on extracting and installing from an MSI File. I am going to include our documentation on how to extract the installer for our products, but with respect to passing the license key, you should be able to install the product first and then within the application pass your License Key by selecting the cogwheel > licensing where it will direct you to a login to confirm your Key. If you are only working from the CLI, you can pass a Flyway -auth -IAgreetoTheEULA command and pass your License Key this way as well. https://documentation.red-gate.com/in/extracting-and-installing-from-the-msi-file https://learn.microsoft.com/en-us/windows/win32/msi/command-line-options?redirectedfrom=MSDN Let me know if this doesnt work for you for some reason. / comments
Good Day dontflyway,Thanks for reaching out to Redgate Support regarding your questions on extracting and installing from an MSI File. I am going to include our documentation on how to extract the ...
Thanks dontflyway, You would install the product first, and then once the product is installed, you will pass the license key directly in the application. Inside of Flyway Desktop there is a licensing sign in option where you can pass your license key to authenticate, I do not believe there is a manner to pass your license directly in the MSI Transforms file. Best Regards, Christian Perez / comments
Thanks dontflyway,You would install the product first, and then once the product is installed, you will pass the license key directly in the application. Inside of Flyway Desktop there is a licensi...
Good Afternoon Wes, I am sorry to hear you are having difficulties when using SQL Prompt, lets see if we can get this fixed up for you. The errors that you are seeing returned in Prompt for your code, is it the same message being returned or a variety of errors? Could you share with me what errors you are receiving and why they are actually correct? Prompt can sometimes call out columns when they have not been fully qualified so I am curious what messages you are receiving. Best Regards, Christian Perez / comments
Good Afternoon Wes,I am sorry to hear you are having difficulties when using SQL Prompt, lets see if we can get this fixed up for you. The errors that you are seeing returned in Prompt for your cod...
Hi @ejameslee3, Replying on this on DanC's behalf as he is out currently. Seems our developers are having trouble replicating this behavior but development came across the following article and are asking if you have had already tried these steps as we think they may be helpful in rectifying this error. https://littlekendra.com/2018/10/03/sql-change-automation-visual-studio-and-the-unknown-sql-server-platform-error/ Let us know if the above helps you. / comments
Hi @ejameslee3,Replying on this on DanC's behalf as he is out currently.Seems our developers are having trouble replicating this behavior but development came across the following article and are a...
Hi Garth, Thanks for following up, you are absolutely right, I was misreading that same compatibility table you referenced, apologies for any confusion I caused. That being said, SCA supports all flavours of SQL Server (Including Azure SQL DB) with the exception of Azure SQL Database Managed Instances, however, the Azure Managed Instances while not officially supported, will probably still work, you just have to take under consideration that you would be unable to raise a support ticket if anything went wrong. Regards, Christian Perez / comments
Hi Garth,Thanks for following up, you are absolutely right, I was misreading that same compatibility table you referenced, apologies for any confusion I caused. That being said, SCA supports all fl...
Hi Garth, Thanks for reaching out to Redgate Support regarding your SCA 4 compatibility question. In this case SCA 4 only supports SQL Server Databases and Azure SQL Database Managed Instances, however, they should be supported both as the development and source environment database if they fall into either of the aforementioned categories. / comments
Hi Garth,Thanks for reaching out to Redgate Support regarding your SCA 4 compatibility question. In this case SCA 4 only supports SQL Server Databases and Azure SQL Database Managed Instances, howe...
Hello _Stefan, Thanks for following up with the dynamic SQL I requested. I found that in my testing I was having suggestions returned back whenever I switched the single quotes to double quotes such as "[schema].[tab le_name]" . (Most database systems also allow for double quotes) Could I have you try this and let me know if you run into any issues? / comments
Hello _Stefan,Thanks for following up with the dynamic SQL I requested. I found that in my testing I was having suggestions returned back whenever I switched the single quotes to double quotes such...