[Liquibase-user] New Topic: Problems with a migration using Liquibase

[Liquibase Community Forum]

A new topic, 'Problems with a migration using Liquibase', has been made on a board you are watching.

You can see it at
http://liquibase.org/forum/index.php?topic=839.new#new

The text of the topic is shown below:

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:
1) use Liquibase to generate an initial changelog from the oracle database
2) 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.

Unsubscribe to new topics from this board by clicking here: http://liquibase.org/forum/index.php?action=notifyboard;board=1.0

Regards,
The Liquibase Community Forum Team.