Our team has the following problem. We would like to start using Liquibase and start developing with local databases. Our existing application uses a oracle database and the local databases will be postgresql.
We have the following plan:
- use Liquibase to generate an initial changelog from the oracle database
- use the initial changelog to populate the postgresql databases.
Question 1: Is this a sound plan, or are we missing something?
The changelog generated at step 1 contains type information that are not compatible for step 2. For example there is a column tag with type=“VARCHAR2(255 BYTE)”. The SQL then contains this literal type information.
Question 2: Why are these non-generic types generated?
Question 2a: Could this be a jdbc driver problem?
Any help would be appreciated.