Activity overview
Latest activity by Christian Perez
Hi mbarbhaya , Thanks for reaching out to Redgate Support. Based off your initial description it seems as if you would benefit from our SQL Compare application where you can provide SQL Compare with 2 databases (Which can both exist on different servers) and then SQL Compare will perform a comparison of the two databases and can deploy the changes from 1 database to another to make them identical or to deploy a few tables only. Does the above sound like what you are aiming to perform here? / comments
Official comment
Hi mbarbhaya , Thanks for reaching out to Redgate Support. Based off your initial description it seems as if you would benefit from our SQL Compare application where you can provide SQL Compare wit...
Hi James, Given these behavioral changes you are seeing seem to be caused by the amount of whitespace in your script, could I suggest that you try going into your SQL Compare Options and check off the comparison option for “Ignore whitespace” and then try this test again and let us know if any change in behavior occurs? Cheers, Christian Perez Product Support Engineer / comments
Hi James, Given these behavioral changes you are seeing seem to be caused by the amount of whitespace in your script, could I suggest that you try going into your SQL Compare Options and check off ...
Hi ahraitch , Thanks for reaching out to Redgate Support and sorry for the delay in my initial response. In this case what I would like you to do is double check we are running our queries from the correct interface window, so if you were to right-click on the dbo.clanPeople table in the Object Explorer and select the option “Select Top 1000 rows” and then reattempt to run Alter TABLE dbo.ClanPEOPLE ADD peopleSpouseID Nchar(10); Is Alter still not recognized? Cheers, Christian Perez Product Support Engineer / comments
Official comment
Hi ahraitch ,Thanks for reaching out to Redgate Support and sorry for the delay in my initial response. In this case what I would like you to do is double check we are running our queries from the ...
HI James, Apologies on the delay getting back to this. Let me review through your new entries and try testing with the amount of whitespace I am passing in this time around. Should have more for you by this afternoon. Cheers, Christian Perez Product Support Engineer / comments
HI James, Apologies on the delay getting back to this. Let me review through your new entries and try testing with the amount of whitespace I am passing in this time around. Should have more for yo...
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...