Comments
Sort by recent activity
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...
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...