Activity overview
Latest activity by emmar00
That's what enabling outOfOrder would do for you. Or at least, it will enable you to execute script 12000, then 30003, then 21002 without it throwing errors. When it comes to actually deploying the changes, that might be more a question of your CI/CD rules. One team I work with has the standard that each deployment target has a branch (so a beta branch, a main/production branch) and any new migrations are first merged into those branches before deployment occurs. / comments
That's what enabling outOfOrder would do for you. Or at least, it will enable you to execute script 12000, then 30003, then 21002 without it throwing errors.When it comes to actually deploying the ...
One strategy could be to use different numbering for each team. You'd have to enable out of order migrations, but then you can achieve some separation between teams while still being able to move anyone's changes to any environment. So for example, Team 1 will start their migrations at number 10000, Team 2 will start with 20000, and Team 3 will start with 30000. That gives you 10,000 migrations per team until you run out. At that point you should probably be doing a rebaseline anyway. / comments
One strategy could be to use different numbering for each team. You'd have to enable out of order migrations, but then you can achieve some separation between teams while still being able to move a...
Having just tried it, it seems that all that is needed is to simply put the two search terms in the search box, separated by a space. (SQL Search 3.9.3.6351) [image] One downside is that you cannot use “Match whole words only” to insist that each term is a whole word. (For example, to exclude matches of “Donec” for “nec”.) That will make it search for both words together as a phrase ("nec ipsum"). I do agree, it would be preferable to have support for more “standard” search operators like quotes and maybe some AND/OR logic. / comments
Having just tried it, it seems that all that is needed is to simply put the two search terms in the search box, separated by a space. (SQL Search 3.9.3.6351)One downside is that you cannot use “Mat...
Have you restarted the Azure pipeline service since you set up Flyway? I just ran into this myself in Azure DevOps. Agent service was up, I added the Flyway key, and ADO just refused to read it even though it was clearly and correctly set in the system PATH environment variable. I just had to open Services and restart the corresponding Azure Pipeline Agent service. / comments
Have you restarted the Azure pipeline service since you set up Flyway?I just ran into this myself in Azure DevOps. Agent service was up, I added the Flyway key, and ADO just refused to read it even...
Just running flyway auth or rather flyway auth -IAgreeToTheEula didn't work as they complained about me being offline. --- I was able to get it working with an offline permit as described on the Licensing page. I originally misunderstood what I needed to run and was trying to do flyway auth -offlinePermitPath=wherever , which would still say I was offline. Rather, the file just needs to be present somewhere and then you can proceed to invoke the other Flyway verbs. For example, flyway version -offlinePermitPath=wherever returns Enterprise as desired. Or if you set up the environment variable FLYWAY_OFFLINE_PERMIT_PATH as described on the offline permit path page, then you don't have to pass the argument either. --- Another, somewhat less convenient, approach I found was that running "C:\Program Files\Git\git-bash.exe" in the terminal launched by Flyway will open a new Git Bash terminal in the current working directory with the REDGATE_LICENSING_PERMIT variable still set, which sets it up with Enterprise from the get-go. / comments
Just running flyway auth or rather flyway auth -IAgreeToTheEula didn't work as they complained about me being offline.---I was able to get it working with an offline permit as described on the Lice...
Running Git Bash with Flyway Enterprise
I'm working on Windows, where I like using Git Bash for CLI work better than the cmd terminal. It's more flexible about paths and quotes, plus the colorful input lines help to separate the commands...
9.1.0.0 missing SQLFluff bundle
I wanted to play with “check -code”, only to receive “WARNING: Could not find Redgate Bundle SqlFluff engine: C:\Program Files\Red Gate\Flyway Desktop\flyway\lib\sqlfluff\flyway_sqlfluff_runner.exe...
I've done something like this with SQL Server. 1. Change your development database link to point to prod 2. Save any updated objects into your schema model 3. Change your development database back to dev 4. Use the Update development pane to push the changes from your schema model into the dev database Assuming test/uat also need to be updated, I would recommend generating the migration script and using that to deploy to test/uat, then doing a skipExecutingMigrations move for prod. / comments
I've done something like this with SQL Server. 1. Change your development database link to point to prod2. Save any updated objects into your schema model3. Change your development database back to...