Create another database from changelog: automatic data type conversion issue

General Discussion
1

I get the changelog from PostgreSQL database with the command:

  1. liquibase \
  2.    --driver=org.postgresql.Driver \
  3.    --classpath="C:\db_drivers\postgresql-9.3-1102.jdbc3.jar" \
  4.    --changeLogFile="./postgresql_changelog.xml" \
  5.    --url="jdbc:postgresql://localhost:5432/postgres" \
  6.    --username=schema_name_here \
  7.    --password=************** \
  8.    --logLevel=debug \
  9.    --defaultSchemaName=sep \
  10.    generateChangeLog

Here is a fragment of postgresql_changelog.xml:

  1. ...                                                                                                                                                                                                                                                 ...

Now I want to create the same objects and the same relationships in another database (Oracle):

  1. liquibase    --driver=oracle.jdbc.OracleDriver    --classpath="C:\db_drivers\ojdbc14.jar"    --changeLogFile="./postgresql_changelog.xml"    --url="jdbc:oracle:thin:@ip_here:orabeta"    --username=***    --password=***    update

But it does not work: ORA-00902

It is possible to get changelog from one database and update another database in different RDBMS server from this changelog? I need to get automatic data type conversion.

2

The answer is -  yes . But it is necessary to manually correct the data types in the generated file. Data types are not converted automatically.