Comments
Sort by recent activity
As a temporary work around, you may be able to overcome the issue by either Explicitly defining the exact assembly path via MandatoryPath or Defining a directory hint path Please see https://documentation.red-gate.com/sa/troubleshooting/unexpected-behavior-and-technical-questions/how-smartassembly-searches-for-dependencies I'd expect the former to be more accurate, but if the second option works for you, it will require less effort. / comments
As a temporary work around, you may be able to overcome the issue by eitherExplicitly defining the exact assembly path via MandatoryPathorDefining a directory hint pathPlease see https://documentat...
Hello @lukasz, Yes we've reproduced the behaviour you've described and are presently tracking this on our internal reference SA-2490. Once a fix is released this reference will appear in the release notes, but I'll also make a note to come back here and update you. / comments
Hello @lukasz,Yes we've reproduced the behaviour you've described and are presently tracking this on our internal reference SA-2490. Once a fix is released this reference will appear in the release...
Hello Groucho, From your description this sounds like the inbuilt T-SQL parser is tripping over something. Given it will be particular to your scripts, I'll contact you directly on how we can identify the issue. If the steps are useful I'll update the public post on how we approached it so it may help others in the future. / comments
Hello Groucho, From your description this sounds like the inbuilt T-SQL parser is tripping over something. Given it will be particular to your scripts, I'll contact you directly on how we can ident...
As of version 5.14.10.0 it's now possible to enable undo scripts via the UI. Within each project there is now a cog icon for configuration that will present this option. [image] [image] The former config file setup remains viable also. / comments
As of version 5.14.10.0 it's now possible to enable undo scripts via the UI.Within each project there is now a cog icon for configuration that will present this option.The former config file setup ...
Hello TShiner, The most immediate answer is unfortunately no, taken from the below documentation, "A SQL Source Control project can contain one Pre-Deployment script and one Post-Deployment script." Please see https://documentation.red-gate.com/soc/common-tasks/working-with-pre-post-deployment-scripts If you want to keep the current tooling, you might be able to extend the longevity with some guard clauses in your scripts to define individual behaviour per environment. I can't clearly tell if you mean multiple development environments, or rather if you mean promoting changes upstream. However if it were the former you would have multiple Source Control project and as a consequence multiple pre & post deployment scripts as a result. Assuming it is the latter, SQL Change Automation, or our latest tooling available in Flyway Desktop may suit you better; Flyway Desktop is closer to the existing SQL Source Control interface you are familiar with. / comments
Hello TShiner,The most immediate answer is unfortunately no, taken from the below documentation, "A SQL Source Control project can contain one Pre-Deployment script and one Post-Deployment script."...
Hi umadevinalluri, As you've moved from v6 to v8, this change is now incorporated https://github.com/flyway/flyway/issues/2984, so you might need to update your class path? / comments
Hi umadevinalluri,As you've moved from v6 to v8, this change is now incorporated https://github.com/flyway/flyway/issues/2984, so you might need to update your class path?
Hello nddymyke, I'm afraid not presently. Our SQL and Oracle comparison products can only be used to compare between 'like for like' respectively. You could potentially use our products to script out the dbs to migration files and then use this information to guide your choices, but your mileage would be highly variable due to the differences in technology and the feature sets potentially being used in either instance. Kind regards, Peter Redgate Product support / comments
Hello nddymyke,I'm afraid not presently. Our SQL and Oracle comparison products can only be used to compare between 'like for like' respectively.You could potentially use our products to script out...
Hello again, As of v10.11.0.26431, this issue of the buttons being offscreen has been fixed. Thank you for reporting it and helping us improve our product. If this resolves your issue please could you let us know by dropping a comment or marking an accepted answer. Many thanks. Peter Redgate Product Support / comments
Hello again,As of v10.11.0.26431, this issue of the buttons being offscreen has been fixed. Thank you for reporting it and helping us improve our product.If this resolves your issue please could yo...
Thank you, yes as you suspected, the screenshot on the other site is a little out of date, the functionality still exists, but has moved. In your screenshot, please select 'Edit formatting styles' near the top of the screen you are on, you can also navigate to the same point directly in the SQL Prompt drop down in SSMS with the same option. This screen will the list the available styles, the default ones that come with the product and any you have created. You can edit your own, whereas the default ones can only be viewed or copied. I'll assume you don't already have a custom style (if you do, please skip step 1) 1. Click '+ Create a style' and name the new style 2. Select your new style, you'll see in the bottom right corner, the view option has changed to 'Edit style' 3. Clicking 'Edit style' will present the customisation screen you are looking for and you can define the casing options as shown below [image] The functionality is detailed here, thought admittedly the options are not exhaustively listed https://documentation.red-gate.com/sp/sql-code-formatting-and-styles/customizing-your-formatting-style [image] Kind regards, Peter Redgate Product Support / comments
Thank you, yes as you suspected, the screenshot on the other site is a little out of date, the functionality still exists, but has moved.In your screenshot, please select 'Edit formatting styles' n...
Good morning Mr www, Thank you for your query, what platform are you using SQL Prompt on please? Would you please be able to share a screenshot of what you do see under the styles option? Lastly, are you presently using a custom style or one of the default ones? Kind regards, Peter Redgate Product Support / comments
Good morning Mr www,Thank you for your query, what platform are you using SQL Prompt on please?Would you please be able to share a screenshot of what you do see under the styles option?Lastly, are ...