User profile for JR_AUS

Terrific, many thanks!

0 votes

Dan_J said: Hi @JR_AUS, Thanks for reaching out to us regarding this. My understanding (and I've just double checked this within SQL History) is that it is currently only possible to "un-star" queries from the main query list, not within the starred queries section also. I appreciate a change to this functionality would be useful to you and so it might be best to log a feature request on our SQL Prompt UserVoice page: https://redgate.uservoice.com/forums/94413-sql-prompt. That way our development team will have visibility of it. Many thanks, Dan. I will log that request. EDIT: This response (my own) accidentally marked as an answer by me. / comments

Dan_J said: Hi @JR_AUS,Thanks for reaching out to us regarding this.My understanding (and I've just double checked this within SQL History) is that it is currently only possible to "un-star" ...

0 votes

StephanieHerr said: You can continue to use SQL Source Control for Object Locking while tracking your database changes and generating migrations for deployment with Flyway. If you'd like to see this directly in Flyway, please add a suggestion to our UserVoice site - https://redgate.uservoice.com/forums/949477-flyway. Thank you, Stephanie. We have decided to use SQL Source Control exclusively, as Flyway does not handle our many cross-database dependencies very well. / comments

StephanieHerr said: You can continue to use SQL Source Control for Object Locking while tracking your database changes and generating migrations for deployment with Flyway. If you'd like to ...

0 votes

Peter_Laws said: Hello JR_AUS, thanks for the question. ...the prefered and encouraged dev configuration is dedicated... Thanks Peter, understood. The reality, of course, is that, for various reasons, dedicated development environments aren't always possible or desirable (we know there are pros and cons to shared and dedicated). In fact, we have met some difficulties in setting up Flyway in our enterprise environment because it has a bent toward dedicated developer databases. Our team is following the current recommended advice for a shared environment from the link you provided, which is: Recommendations if you must use a shared development database environment If you are unable to provision dedicated development environments, for example using Flyway Enterprise's cloning capability, Flyway Desktop can be used with a shared development database. Please note that: We recommend that you leave the Repeatable Migrations feature disabled in the project if you utilize any form of branching in your version control system Each person generating migrations must have their own shadow database or shadow schema Many thanks for you response. / comments

Peter_Laws said: Hello JR_AUS, thanks for the question....the prefered and encouraged dev configuration is dedicated... Thanks Peter, understood. The reality, of course, is that, for variou...

0 votes

Peter_Laws said: Hello JR_AUS, thanks for the question. ...the prefered and encouraged dev configuration is dedicated... Thanks Peter, understood. The reality, of course, is that, for various reasons, dedicated development environments aren't always possible or desirable (we know there are pros and cons to shared and dedicated). In fact, we have met some difficulties in setting up Flyway in our enterprise environment because it has a bent toward dedicated developer databases. Our team is following the current recommended advice for a shared environment from the link you provided, which is: Recommendations if you must use a shared development database environment If you are unable to provision dedicated development environments, for example using Flyway Enterprise's cloning capability, Flyway Desktop can be used with a shared development database. Please note that: We recommend that you leave the Repeatable Migrations feature disabled in the project if you utilize any form of branching in your version control system Each person generating migrations must have their own shadow database or shadow schema Many thanks for you response. / comments

Peter_Laws said: Hello JR_AUS, thanks for the question....the prefered and encouraged dev configuration is dedicated... Thanks Peter, understood. The reality, of course, is that, for variou...

0 votes

JR_AUS said: I have run into an issue where Flyway, when creating a baseline for an existing database, does not do a test for existence of database users; it simply writes a CREATE USER statement, which then fails during the comparison because the user already exists. What I'd like to do is open the baseline file from the Git repo and simply add a test for existence of database users to that script. I am wondering if doing this will have unintended consequences on Flyway version tracking? I created a ticket with Redgate and the solution is to modify the baseline file so that it includes the required test for existence, then commit changes. Having done this and re-run Flyway there are no negative impacts. / comments

JR_AUS said: I have run into an issue where Flyway, when creating a baseline for an existing database, does not do a test for existence of database users; it simply writes a CREATE USER state...

0 votes

JR_AUS said: ...I am wondering if it is just ok to create the database project folders in that repo? Answered my own question - I just created the project in a new folder in an existing local repo and Flyway recognised it. Very simple! / comments

JR_AUS said: ...I am wondering if it is just ok to create the database project folders in that repo?Answered my own question - I just created the project in a new folder in an existing local repo ...

0 votes

JR_AUS said: Victoria W said: ... please can you downgrade to the previous version until we have a fix: https://download.red-gate.com/checkforupdates/SQLSearch/SQLSearch_3.6.0.3167.exe I have downloaded this version and installed to SSMS 19.0.20209. The Search app toolbar does not appear and is not available to add when trying to customise the menu. I have uninstalled and reinstalled multiple times. Update: I uninstalled SSMS 19.0.2 and reinstalled 19.0.1 and SQL Search 3.6.1.3286 works. SQL Search is fairly important to me [image] / comments

JR_AUS said: Victoria W said: ... please can you downgrade to the previous version until we have a fix:https://download.red-gate.com/checkforupdates/SQLSearch/SQLSearch_3.6.0.3167.exe ...

0 votes

Victoria W said: ... please can you downgrade to the previous version until we have a fix: https://download.red-gate.com/checkforupdates/SQLSearch/SQLSearch_3.6.0.3167.exe I have downloaded this version and installed to SSMS 19.0.20209. The Search app toolbar does not appear and is not available to add when trying to customise the menu. I have uninstalled and reinstalled multiple times. / comments

Victoria W said: ... please can you downgrade to the previous version until we have a fix:https://download.red-gate.com/checkforupdates/SQLSearch/SQLSearch_3.6.0.3167.exe I have downloaded ...

0 votes

Hi @Jon_Kirkwood and @PeterDanielsCRB, I thought I might chip in my thoughts, having found this conversation as a result of some months of frustration using Flyway, as a Flyway Enterprise subscriber. I'll begin by saying that I think Red Gate's direction and progress for Flyway makes sense, and I can see that it will, ultimately, be an invaluable tool for database teams. That said, over the last few months I have had very long days trying to get it to work in our environment. The specific issue I have had has been with cross-database dependencies, including circular dependencies; Flyway just doesn't handle these well when a deployment to a database we can control has a dependency in an external database that we cannot. Where the external database has an object dropped that is referenced in our baseline, even if we are no longer using that object, Flyway simply stops with an error, even though the change could otherwise be deployed successfully. The behaviour makes sense, as Flyway sees an inconsistency between the baseline and the intended deployment. However, that is small comfort when there are changes that need deploying, which will function as intended, and the tool won't allow it. I recognise that Phil Factor and other celebrated database professionals have written articles to address the issues I raise here, however these solutions don't appear to scale well (we have thousands of dependencies). Further, with a very small team, time to implement them alongside the daily need to deploy changes makes them unattractive at best. The reason I am posting this comment here is because I noticed that our Flyway Enterprise subscription currently includes SQL Change Automation, SQL Source Control and SQL Clone, for which I am now thankful! In short, the Flyway issues I have had around maintaining state in source control and being able to deploy to various environments with many external dependencies are easily managed using these older tools. SQL Clone is an amazing tool and makes trivial the task of setting up databases on developer machines. Add to that that those same databases can then be source controlled using SQL Change Automation, SQL Source Control, or a combination of each, and easily deployed with no errors. My hope is that Red Gate takes its time in changing customers over to Flyway and covers off some of the difficulties that I have mentioned, that are already addressable with existing toolsets. cc: @Peter_Laws / comments

Hi @Jon_Kirkwood and @PeterDanielsCRB,I thought I might chip in my thoughts, having found this conversation as a result of some months of frustration using Flyway, as a Flyway Enterprise subscriber...

0 votes

How can we help you today?

JR_AUS

Comments