Activity overview
Latest activity by JR_AUS
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 ...
Terrific, many thanks! / comments
Terrific, many thanks!
Flyway 6.5.0 toml file and git
Howdy. Wondering if the flyway.user.toml file should be added to gitignore?
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" ...
SQL History - Starred Queries
I've checked at the help document located here, but I don't seem to be able to easily "un-star" SQL queries. Clicking on the star icon to filter them opens the advanced filter window, which offers ...
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...
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...
Object locking in Flyway Desktop
One for the Redgate team:The product "SQL Source Control" includes a very handy tool that enables the locking of database objects, preventing accidental changes. This is particularly useful in the ...
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...