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?
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?