I have a requirement where I have two tables in two different databases, where one is source and other is destination. I have to pull the table schema between source table and destination table and see if it is backward compatible. Suppose user added a new column or an existing data type is changed for a column in the source I should be able to generate a DDL alter table query to make the changes in the destination table and should work for any SQL database.
I have looked into tools like flyway and liquibase to see if it can do the required changes, but It doesn't fit the requirement. Is there anyway to meet such requirement with any existing tools like liquibase or flyway? Iam writing the code in Java.
If anyone had similar situation before please throw some light into this.