Comments
1 comment
-
Official commentHi Norie,
Thanks for reaching out to Redgate Support and sorry to hear you are having some trouble with your Flyway migration. Would you be able to share an example of the script syntax that is giving you trouble and I can then better tell you what Flyway is doing when it generates that script. Also, if you could share the exact erroring being returned when this migration fails?
Additionally, there are some comparison option settings that should let you edit how ALTER and re-runnable script generation settings for idempotency are handled by Flyway.
Feel free to also include your Flyway logs here as they should have some logging as to why your migration failed.
Add comment
Please sign in to leave a comment.
We are currently testing the Flyway Desktop for consideration of usage in our company. I am having an issue with the automatic migration DDL creation of Flyway. I creates a script, but it also has the ALTER line where it sets the table owner to the current DB, so when you use it as with the Flyway migrate command, to reflect on another DB like the shadow DB and stg DB it gives an error of no user as the one used in the ALTER command automatically created with the DDL. is that normal?