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