# Create another database from changelog: automatic data type conversion issue

**URL:** <https://forum.liquibase.org/t/create-another-database-from-changelog-automatic-data-type-conversion-issue/3092>\
**Category:** General Discussion\
**Created:** [August 28, 2014, 11:55am UTC](https://forum.liquibase.org/t/create-another-database-from-changelog-automatic-data-type-conversion-issue/3092 "2014-08-28T11:55:00Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![strolling.code](https://avatars.discourse-cdn.com/v4/letter/s/2acd7d/32.png) [@strolling.code](https://forum.liquibase.org/u/strolling.code)\
**Post date:** [August 28, 2014, 11:55am UTC](https://forum.liquibase.org/t/create-another-database-from-changelog-automatic-data-type-conversion-issue/3092/1 "2014-08-28T11:55:00Z")

</div>

I get the changelog from PostgreSQL database with the command:

1. liquibase \
2. &nbsp;&nbsp; --driver=org.postgresql.Driver \
3. &nbsp;&nbsp; --classpath="C:\db\_drivers\postgresql-9.3-1102.jdbc3.jar" \
4. &nbsp;&nbsp; --changeLogFile="./postgresql\_changelog.xml" \
5. &nbsp;&nbsp; --url="jdbc:postgresql://localhost:5432/postgres" \
6. &nbsp;&nbsp; --username=schema\_name\_here \
7. &nbsp;&nbsp; --password=\*\*\*\*\*\*\*\*\*\*\*\*\*\* \ 
8. &nbsp;&nbsp; --logLevel=debug \ 
9. &nbsp;&nbsp; --defaultSchemaName=sep \
10. &nbsp;&nbsp; generateChangeLog

 

Here is a fragment of postgresql\_changelog.xml:

 
1. ... &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; ... 

 

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

 
1. liquibase &nbsp;&nbsp; --driver=oracle.jdbc.OracleDriver &nbsp;&nbsp; --classpath="C:\db\_drivers\ojdbc14.jar" &nbsp;&nbsp; --changeLogFile="./postgresql\_changelog.xml" &nbsp;&nbsp; --url="jdbc:oracle:thin:@ip\_here:orabeta" &nbsp;&nbsp; --username=\*\*\* &nbsp;&nbsp; --password=\*\*\* &nbsp;&nbsp; update

 

But it does not work: [ORA-00902](http://docs.oracle.com/cd/B10501_01/server.920/a96525/e900.htm)

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.

---

<div class="post-metadata">

**Author:** ![un1409155255202r28id](https://avatars.discourse-cdn.com/v4/letter/u/7ab992/32.png) [@un1409155255202r28id](https://forum.liquibase.org/u/un1409155255202r28id)\
**Post date:** [August 28, 2014, 11:55am UTC](https://forum.liquibase.org/t/create-another-database-from-changelog-automatic-data-type-conversion-issue/3092/2 "2014-08-28T11:55:00Z")

</div>

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