User profile for Peter_Laws

Hi JonBrune, Thanks for thinking of us, I'll add the obligatory documentation at the end, but first I'll talk you through it because docs can be a little dry. Firstly version numbers have to be unique and the description isn't factored in, it's just the value preceding the double underscore. If you attempt it, you'll see this kind of exception: C:\Users\Peter.Laws\Desktop\Flyway\flyway-commandline-9.18.0-windows-x64\flyway-9.18.0>flyway info Licensed to red-gate.com Database: jdbc:postgresql:postgres (PostgreSQL 14.2) ERROR: Found more than one migration with version 1 Offenders: -> C:\Users\Peter.Laws\Desktop\Flyway\flyway-commandline-9.18.0-windows-x64\flyway-9.18.0\sql\V1__first - Copy (2).sql (SQL) -> C:\Users\Peter.Laws\Desktop\Flyway\flyway-commandline-9.18.0-windows-x64\flyway-9.18.0\sql\V1__first - Copy.sql (SQL)By extension, this approach makes the ordering much more intuitive, alphanumeric ordering is typically slower to groc at a glance. For the other points Flyway validate has your back here and will handle each of these scenarios, better yet, you don't actually have to do anything because it's always checked prior to performing a migration. Looking at the schema history table that records the migrations, you'll see a checksum is taken at runtime/ [image] [image] So should a migration be altered (ill intentioned or otherwise) when the scrips are parsed at time of migration, flyway will itnerupt itself and inform you if any script checksums have changed, even if they wouldn't been run (due to having already been deployed) to make sure they aren't unintentionally implemented against another target introducing unknown variables. Regarding order, if a new, earlier version is introduced, flyway will warn you that there are now new, out of order migrations that could be applied, so you can choose how to proceed. Nearly everything I've listed here can be configured, this is just the default behaviour. Thanks for contributing to the forum! Documentation Migrations naming conventions Validate OutOfOrder and CherryPick / comments

Hi JonBrune,Thanks for thinking of us, I'll add the obligatory documentation at the end, but first I'll talk you through it because docs can be a little dry.Firstly version numbers have to be uniqu...

0 votes

Thank you for the question. You're not missing anything. Could you tell us a bit more about your use case please? I follow everything you've described, but the need for multiple projects open simultaneously isn't one that comes up much and we could likely handle it better if we knew the intention for doing so. / comments

Thank you for the question. You're not missing anything.Could you tell us a bit more about your use case please?I follow everything you've described, but the need for multiple projects open simulta...

0 votes

Thank you for highlighting, for your awareness, the github issues are periodically reviewed just like the forums. / comments

Thank you for highlighting, for your awareness, the github issues are periodically reviewed just like the forums.

0 votes

Thanks for mentioning it, I've commented. / comments

Thanks for mentioning it, I've commented.

0 votes

Nicely done, thanks for sharing what worked for you! / comments

Nicely done, thanks for sharing what worked for you!

0 votes

My apologies for the rather weak reply tpurcell, are you able to confirm please that the version of flyway running matches your dependencies and isn't running something older unintentionally?I ask ...

0 votes

Hi ThurlowD, Thanks for raising this, I discovered the issue a little while ago and raised it internally. Further investigation has revealed strangely the issue is caused when a direct connection type is used which results in the timezone not being correctly observed. We've raised the issue with the manufacturer and they have been able to reproduce our findings. This naturally has fairly far reaching and disruptive effects so we're very keen on resolving it quickly, I'll update this thread as soon as we know more. / comments

Hi ThurlowD,Thanks for raising this, I discovered the issue a little while ago and raised it internally. Further investigation has revealed strangely the issue is caused when a direct connection ty...

0 votes

Hi jamal1, Thanks for asking the question! Flyway doesn't govern the connection behaviour, but can be used as an interface to pass the behaviour you're looking for. Please could you try amending your connection string like so and let us know the outcome? jdbc:mysql://localhost:1433/my-db?socketTimeout=2000The timeout value is expressed in milliseconds. / comments

Hi jamal1,Thanks for asking the question!Flyway doesn't govern the connection behaviour, but can be used as an interface to pass the behaviour you're looking for.Please could you try amending your ...

0 votes

Hello JR_AUS, thanks for the question. Probably not in the near future, as you can see here, the prefered and encouraged dev configuration is dedicated so it's less of a priority than in the SQL Source Control context. / comments

Hello JR_AUS, thanks for the question.Probably not in the near future, as you can see here, the prefered and encouraged dev configuration is dedicated so it's less of a priority than in the SQL Sou...

0 votes

Hi plynch1969 Thank you for reporting it, I already have a bug report for this behaviour and the development team are working on it, once resolved it will be referenced under issue 2258. In the meantime, 9.14.1 is the newest version that I'm aware of that's unaffected. / comments

Hi plynch1969Thank you for reporting it, I already have a bug report for this behaviour and the development team are working on it, once resolved it will be referenced under issue 2258.In the meant...

0 votes

How can we help you today?

Peter_Laws

Comments