Comments
Sort by recent activity
Hello Stone, Apologies on the delay, Yes, the explanation makes sense. I installed this version of SQL Data Compare locally in my environment, created two system-versioned tables named Department and filled them both with 5 identical rows of data. My comparison in SQL Data Compare was accurate without any mismatches or errant data being show. Afterwards I added 2 additional rows to only one of the tables but they continue to show up nominally on my end. [image] Are you saying that the Test Database has 17 rows of data and the Production Database has 11 rows of data and when the comparison is performed you cannot see the differences? Would you be able to share your logs from SQL Data Compare? / comments
Hello Stone,Apologies on the delay, Yes, the explanation makes sense. I installed this version of SQL Data Compare locally in my environment, created two system-versioned tables named Department an...
Hi Stone, Sorry to hear you are having issues with system-versioned tables in SQL Data Compare. System Versioned tables should be supported, could you confirm which version of SQL Data Compare you currently have installed? Additionally, do you have a screenshot or example of the results being incorrect, I will need some more context in order to troubleshoot locally in my environment. Best Regards, Redgate Support / comments
Hi Stone,Sorry to hear you are having issues with system-versioned tables in SQL Data Compare. System Versioned tables should be supported, could you confirm which version of SQL Data Compare you c...
Hi Jgannon, Thanks for reaching out to Redgate with your multi-script automation request. The problem in this case is that SQL Multi-script does not have an API or Command Line inteface that can be used to kick off the job in an automated way. A SQL Monitor custom metric maybe a better solution for you. If you'd like to investigate other options then raise a support ticket with support@red-gate.com You might be able to rig up something to meet your needs using the windows scheduler and the sqlcmd command line utility See, http://msdn.microsoft.com/en-us/library/ms170207.aspx. But this isn't something that we could support you with. / comments
Hi Jgannon,Thanks for reaching out to Redgate with your multi-script automation request. The problem in this case is that SQL Multi-script does not have an API or Command Line inteface that can be ...
Great News, glad to hear it. / comments
Great News, glad to hear it.
Hi Kostas_Ch, Thanks for reaching out to Redgate Software with your SQL Prompt inquiry, with respect to being able to remove schemas from intellisense auto-fill I was able to find the following entry which should answer your question: = = = = = The suggestions box is automatically widened to allow space for the schema names, shown in grey to the left of the suggestions: [image] To hide the list of schema (owner) names, click the left arrow [image]
The arrows only affect how object names are displayed in the suggestions box. The schema (owner) name is only inserted into your code when Qualify object names with owner name is selected on the Inserted Code > Qualification options page.
= = = =
Could you try disabling the 'Qualify object names with owner name' Prompt setting and seeing if you have any change in behavior?
https://documentation.red-gate.com/sp/sql-code-completion-and-intellisense/inserting-suggestions-into-your-code#Insertingsuggestionsintoyourcode-DisplayingschemanamesDisplayingschema(owner)names
/ comments
Hi Kostas_Ch,Thanks for reaching out to Redgate Software with your SQL Prompt inquiry, with respect to being able to remove schemas from intellisense auto-fill I was able to find the following entr...
Hello Schachar, Thanks for reaching out to Redgate Software regarding your SQL Prompt inquiry. I believe you may have some luck using SQL Prompt's Code Completion and Ranked Suggestion features in this case. I am going to include the link to our documentation on both topics so you can review. Ranked Suggestion: https://documentation.red-gate.com/sp/sql-code-completion-and-intellisense/inserting-suggestions-into-your-code#Insertingsuggestionsintoyourcode-RankedSuggestions Code Completion: https://documentation.red-gate.com/sp/sql-code-completion-and-intellisense/using-and-configuring-code-completion-suggestions-quick-ref Lastly, an alternative solution you may wish to consider is utilizing a snippet in your environment to save a pre-written join clause as an alias like join1 and then you can just use the snippet to auto-write the join query. https://documentation.red-gate.com/sp/sql-code-snippets Hopefully the above gives you some ammunition to determine which solution is best for you. But let me know if you have any follow up concerns. / comments
Hello Schachar,Thanks for reaching out to Redgate Software regarding your SQL Prompt inquiry. I believe you may have some luck using SQL Prompt's Code Completion and Ranked Suggestion features in t...
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 ...