Activity overview
Latest activity by Christian Perez
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...
Hello Ram Kumar, Thanks for reaching out to Redgate Support, sorry to hear you got stuck with your Flyway project. In this case, could you let me know what kind of Database you are working with? I ask as some Database types should automatically rollback any changes performed mid migration when a migration fails, however other still do not. In either case, when the migration initially failed, you may have had to run the undo migration to reintroduce the name column which was dropped. (assuming you have undo migrations being generated) Once the repair was run, the flyway_schema_history table no longer knows about the failed migration and then the subsequent migration fails as you said. Best Regards, Christian Perez Product Support Engineer / comments
Official comment
Hello Ram Kumar, Thanks for reaching out to Redgate Support, sorry to hear you got stuck with your Flyway project. In this case, could you let me know what kind of Database you are working with? I ...
Hi Shelly, Thanks for reaching out to Redgate Support. Sorry to hear you are having an unexpected behavior showing up in your SQL Data Compare Application. In this case, I would like to replicate this behavior if possible so we can get this corrected, would you be able to share a few details with me? Version of SQL Data Compare installed Schema-Only Creation Script of Table that is showing 0's as Null. (If multiple let me know) Screenshot of the behavior I will then use a data generation tool on my end to try and mimic your data and this behavior. If you prefer to provide a full backup, I can generate a file request link for you. / comments
Official comment
Hi Shelly,Thanks for reaching out to Redgate Support. Sorry to hear you are having an unexpected behavior showing up in your SQL Data Compare Application. In this case, I would like to replicate th...
Hi ABI, Thanks for reaching out to Redgate Support and sorry to hear you are having some trouble with Descriptions on your Stored Procedures. In this case, I am curious if the description was actually added but is just not visible when executing the stored procedure. Could I have you try the below please:
In SSMS, navigate to the stored procedure in Object Explorer.
Right-click on the stored procedure and select Properties.
Go to the Extended Properties tab to view the description.
Are you seeing the description listed in the Extended Properties of your SP? / comments
Official comment
Hi ABI,Thanks for reaching out to Redgate Support and sorry to hear you are having some trouble with Descriptions on your Stored Procedures. In this case, I am curious if the description was actual...
Hi Daniel, Thanks for reaching out to Redgate Support regarding your SQL History concern. You are correct that this is present in previous versions as it is by design, see here some details on case sensitivity from our documentation https://documentation.red-gate.com/sp/ssms-tab-management/sql-history/searching-sql-history Why am I not getting the results I expect? Casing of both the words you are searching with and the query text you are searching for can have an effect on the results. To give the likeliest optimal results, compound words are broken up when searching. To do this, capital letters are treated as a word boundary. For example, if the table CustomerOrders appears in a query, this will be broken into Customer, Orders and CustomerOrders when searching. Searching for any of these will get a result. If the CustomerOrders table was defined as Customerorders instead, searching for customer or orders will not find it. The same word boundary logic is applied for the text being used in the search. If you don't find what you expect to, try to change the search text slightly by lower casing it and splitting words apart. That being said, if you would like us to add a feature to toggle case sensitivity for search results, I would recommend submitting an entry to our SQL Prompt User Voice forum so other Prompt users can vote on it and then possibly be implemented by development. https://redgate.uservoice.com/forums/94413-sql-prompt / comments
Official comment
Hi Daniel, Thanks for reaching out to Redgate Support regarding your SQL History concern. You are correct that this is present in previous versions as it is by design, see here some details on case...
Hi Dwaine, Thanks for reaching out to Redgate Software and sorry to hear you are having some SQL Prompt issues after upgrading. In this case, could I kindly request that you include your SQL Prompt logs for review here? Additionally, I am curious if you would be willing to uninstall and reinstall the version prior to 10.16.3 and see if this issue goes away. If there are any snippets or information you want to backup I believe the path is in Appdata/local/redgate/SQLPrompt. You can find all publicly available versions of Prompt Here: http://download.red-gate.com/checkforupdates/SQLPrompt/ / comments
Official comment
Hi Dwaine,Thanks for reaching out to Redgate Software and sorry to hear you are having some SQL Prompt issues after upgrading. In this case, could I kindly request that you include your SQL Prompt ...