Comments
Sort by recent activity
Hi Adam, Thanks for reaching out to Redgate Support regarding your multiscript feature request. In this case I would suggest you create an entry on our User Voice page where end users can vote on features they want implemented in future Redgate Releases. Here is the link for SQL Toolbelt Essentials which is where you would submit your entry: https://redgate.uservoice.com/forums/936348-sql-toolbelt-essentials?query=multiscript / comments
Official comment
Hi Adam, Thanks for reaching out to Redgate Support regarding your multiscript feature request. In this case I would suggest you create an entry on our User Voice page where end users can vote on f...
Confirmed the details above are valid for SQL Data Compare. JSON appears to be in preview and and it's Azure only for the time being. / comments
Confirmed the details above are valid for SQL Data Compare. JSON appears to be in preview and and it's Azure only for the time being.
Hi James, Thanks for your patience while we continued testing this and for providing your T-SQL Script. I was able to test this locally in my environment using SQL Compare version 15.4.11 and after deploying the stored proc to an empty database I made the same commenting change on the RAISEERROR section of your example and I am not seeing the behavior you are reporting in this case. I am still seeing: CREATE PROC [dbo].[proc] On both ends of the comparison and after the deployment. Could I trouble you to upgrade SQL Compare and repeat this test and let us know if the issue is now resolved? / comments
Hi James,Thanks for your patience while we continued testing this and for providing your T-SQL Script. I was able to test this locally in my environment using SQL Compare version 15.4.11 and after ...
Hi Norie, Thanks for reaching out to Redgate Support and sorry to hear you are having some trouble with your Flyway migration. Would you be able to share an example of the script syntax that is giving you trouble and I can then better tell you what Flyway is doing when it generates that script. Also, if you could share the exact erroring being returned when this migration fails? Additionally, there are some comparison option settings that should let you edit how ALTER and re-runnable script generation settings for idempotency are handled by Flyway. Feel free to also include your Flyway logs here as they should have some logging as to why your migration failed. https://documentation.red-gate.com/flyway/learn-more-about-flyway/troubleshooting/logging-and-log-files / comments
Official comment
Hi Norie,Thanks for reaching out to Redgate Support and sorry to hear you are having some trouble with your Flyway migration. Would you be able to share an example of the script syntax that is givi...
Hi Doug, Thanks for reaching out to Redgate Support and sorry to hear you are having trouble with finding invalid objects in SQL Prompt. if you click on SQL Prompt > Help > About, what version of SQL Prompt do you have installed. Further more, in that same SQL Prompt > Help Toolbar dropdown you can get a copy of your SQL Prompt logs so we can review, could I trouble you to attach those here as well? Are you seeing any error being reported or are there simply no databases populating in the list when the screen pops up. / comments
Official comment
Hi Doug,Thanks for reaching out to Redgate Support and sorry to hear you are having trouble with finding invalid objects in SQL Prompt. if you click on SQL Prompt > Help > About, what version of SQ...
Hi Steven Perry. Thanks for reaching out to Redgate Support, I do believe that our Flyway product recently started supporting the .json data type for some database types. (I believe it was mysql db type for the first example I saw) However I have not seen this capability propagated to SQL Data Compare quite yet in my recent testing. I would submit an entry on our User Voice page for SQL Data Compare to request this feature be added: https://redgate.uservoice.com/forums/147879-sql-data-compare?query=json I will also escalate this internally and if I hear more will update further details here. / comments
Official comment
Hi Steven Perry. Thanks for reaching out to Redgate Support, I do believe that our Flyway product recently started supporting the .json data type for some database types. (I believe it was mysql db...
Hi James, Thanks for reaching out to Redgate Support regarding your issue with SQL Compare. What version of the product are you using in this case? For testing purposes, would you be able to share the exact T-SQL you are using? I should be able to replicate the behavior once I know the version and syntax. / comments
Official comment
Hi James,Thanks for reaching out to Redgate Support regarding your issue with SQL Compare. What version of the product are you using in this case? For testing purposes, would you be able to share t...
Hi Richard, Appreciate the feedback as well as the workaround steps that you were able to use. I have the steps logged here internally, so if someone searches for this topic in the future these steps should appear in the search. Thanks for taking the time to let us know what worked for you. / comments
Hi Richard, Appreciate the feedback as well as the workaround steps that you were able to use. I have the steps logged here internally, so if someone searches for this topic in the future these ste...
Hi Richard, Thanks for reaching out to Redgate Support regarding your SQL Doc question. I went through our documentation and I agree with you that there does not appear a way to exclude schemas at the command line level. The most relevant portion of the documentation that im sure you already looked at is the following: https://documentation.red-gate.com/sdoc/working-with-projects/setting-up-the-documentation#Settingupthedocumentation-Setup-customization However I am not seeing a manner to exclude based off of schema, only database, table, column, collation, etc. I suggest that you create an entry on our User Voice page for this request so that this can be considered for a SQL Doc update and possibly implemented. https://redgate.uservoice.com/forums/936348-sql-toolbelt-essentials Apologies I was not able to locate a fix in this case. / comments
Official comment
Hi Richard,Thanks for reaching out to Redgate Support regarding your SQL Doc question. I went through our documentation and I agree with you that there does not appear a way to exclude schemas at t...
Hi Dick Kusleika, Thanks for reaching out to Redgate Support and using SQL Prompt, in this case, I am going to include a screenshot of what I see when I execute Ctrl+Shift+X as it does still open SQL History in my lab environment. [image] Is this what you are referring to? From this screen I found if I then do a Ctrl + F, I am put into the search box without using my mouse. / comments
Official comment
Hi Dick Kusleika,Thanks for reaching out to Redgate Support and using SQL Prompt, in this case, I am going to include a screenshot of what I see when I execute Ctrl+Shift+X as it does still open SQ...