Activity overview
Latest activity by AlistairW
Flyway won't change your SQL (except for placeholder replacement but you aren't using that) - all it does is to break it up into statements and pass it to the database driver to be applied to the DB. / comments
Flyway won't change your SQL (except for placeholder replacement but you aren't using that) - all it does is to break it up into statements and pass it to the database driver to be applied to the DB.
We are not aware of any such limitation but it's hard to know exactly what is going on from what you have provided. What is the error you get back from Flyway ? How are you providing the script (e.g. file ?) / comments
We are not aware of any such limitation but it's hard to know exactly what is going on from what you have provided. What is the error you get back from Flyway ? How are you providing the script (e....
Not that I'm aware of, there may be some dark corner of Oracle's sqlplus that does this but Flyway doesn't do any conversions / comments
Not that I'm aware of, there may be some dark corner of Oracle's sqlplus that does this but Flyway doesn't do any conversions
Sorry - there were some infrastructure upgrades last night that probably resulted in the 404 but it is back now. I've just tested this on v10.20.0 (that is not latest but it was to hand) and it does work for me as described in the docs. In my conf/flyway.toml file I have this: [flyway] token = "<redacted>" email = "<redacted>" and when I run Flyway it picks up my key to license the product, if i use the -X flag to get extended debug I can also see the configuration being picked up: ... flyway.detectEncoding -> falseflyway.email -> <redacted> flyway.encoding -> UTF-8 ... flyway.target -> latest
flyway.token -> ********
flyway.validateMigrationNaming -> false ... Is it possible that your TOML configuration file isn't being picked up ? You would see something like this in the extended debug output if Flyway found it ... DEBUG: Loading config file: <your path to flyway>/conf/flyway.toml ...
/ comments
Sorry - there were some infrastructure upgrades last night that probably resulted in the 404 but it is back now. I've just tested this on v10.20.0 (that is not latest but it was to hand) and it doe...
The pasting permit process is problematic, in fact we're in the process of removing it currently. Have a look on this page for the suggested licensing methods: https://documentation.red-gate.com/fd/flyway-licensing-263061944.html I think that the "Online non-interactive flow" and an email/PAT token is what you want on WSL. Flyway will need to be able to read and write to the folder "~/.config/Redgate/Flyway CLI" (see https://documentation.red-gate.com/fd/auth-224919651.html) / comments
The pasting permit process is problematic, in fact we're in the process of removing it currently.Have a look on this page for the suggested licensing methods: https://documentation.red-gate.com/fd/...
You run into the limitations of a point tool - the situation you describe needs some way of coordinating everyone and that is non-trivial. Flyway aims to solve the problem of being able to change your DB in a controlled manner and recreate it's current state should you need to do so. Coordinating development work is a related problem but will involve other tools and practices to solve (Redgate has some but they aren't free) On your specific question though, dev1 would need to clean their development DB and re-apply all the migrations which would correct the ordering to include dev2's changes. / comments
You run into the limitations of a point tool - the situation you describe needs some way of coordinating everyone and that is non-trivial. Flyway aims to solve the problem of being able to change y...
The conventional approach is to check before committing - Flyway uses the version numbers to order your migrations and it may be important which V2 is applied first. An alternative is to embed a timestamp in the version number which makes it very unlikely that you'll get a conflict. You can develop your own process for this or else there is a new verb in preview that can create the empty migration for you - https://documentation.red-gate.com/fd/command-line-add-254155068.html So you'd want something like this to create the file: flyway add -add.description=new_feature -add.addTimestamp=true / comments
The conventional approach is to check before committing - Flyway uses the version numbers to order your migrations and it may be important which V2 is applied first.An alternative is to embed a tim...
Hi there - glad that Flyway has been working for you so well. There isn't currently a way to get Flyway to target multiple DBs in a single call, you have to do as you have done and run multiple instances of Flyway so if you want to bring down the time more then increase the number of parallel instances. That said, you will need adequate resources (memory/CPU) on the devices running Flyway - given that 1 thread took 90 minutes to perform the whole task then having 20 threads take 50 minutes suggests you've got a bottleneck somewhere. I suppose you *could* write your own java application that uses the Flyway libraries to do specific parallel migrations more efficiently than the CLI .... but .... that is a lot of work when you could use AWS/Azure/GCP to spin up the instances you need on demand. / comments
Hi there - glad that Flyway has been working for you so well. There isn't currently a way to get Flyway to target multiple DBs in a single call, you have to do as you have done and run multiple ins...
We tend to place more emphasis on the online docs - https://documentation.red-gate.com/fd/commands-184127446.html It looks like it is typically implemented for new things we are adding to Flyway but never made it consistently into the established verbs / comments
We tend to place more emphasis on the online docs - https://documentation.red-gate.com/fd/commands-184127446.htmlIt looks like it is typically implemented for new things we are adding to Flyway but...
Hmm - it is in there but we updated the version a couple of weeks ago and I wonder if something has changed in SQLFluff to break the integration. If it is possible, I'd use an older Flyway version while we investigate - redgate/flyway:10.19.0 worked for me / comments
Hmm - it is in there but we updated the version a couple of weeks ago and I wonder if something has changed in SQLFluff to break the integration.If it is possible, I'd use an older Flyway version w...