(I apologize if this topic is mentioned in another forum thread)
I know that diff-database (delta sql script) is so limited. I test on oracle 11g database with columns that their datatypes have been changed (many different types of datatypes changes). The generated sql file, or liquibase file, with the diff-database does not present these datatypes modifications in any case.
But I think a diff-database that supports the modification of datatypes can be simply developed (only viewing if the datatype is different, putting the appropiate sql statement, and letting the database driver the responsability to produce a sql exception if there is a syntax fail/error). Could the problem arise from the information that is provided by the driver?
I always work with sql script and so I put the sql syntax. Liquibase presents a modify column refactoring but I think this tag is producing too many controversies…