# Liquibase diifChangeLog Command

**URL:** <https://forum.liquibase.org/t/liquibase-diifchangelog-command/5716>\
**Category:** General Discussion\
**Created:** [July 18, 2021, 2:26pm UTC](https://forum.liquibase.org/t/liquibase-diifchangelog-command/5716 "2021-07-18T14:26:41Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Dikshakapoor](https://avatars.discourse-cdn.com/v4/letter/d/858c86/32.png) [@Dikshakapoor](https://forum.liquibase.org/u/Dikshakapoor)\
**Post date:** [July 18, 2021, 2:26pm UTC](https://forum.liquibase.org/t/liquibase-diifchangelog-command/5716/1 "2021-07-18T14:26:41Z")

</div>

I need the data as well as the schema differences between the 2 databases, so that I can get a changelog corresponding to the difference and then deploy it to my other version,  
but the diff command seems to generate only the schema changes and not the data, how do I get the data changes as well, Simply generating a change Log and then updating results in error since it says table already exists, and thus changes aren’t entertained…

---

<div class="post-metadata">

**Author:** ![rakhi](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.liquibase.org/rakhi/32/288_2.png) [@rakhi](https://forum.liquibase.org/u/rakhi)\
**Post date:** [July 19, 2021, 10:03am UTC](https://forum.liquibase.org/t/liquibase-diifchangelog-command/5716/2 "2021-07-19T10:03:40Z")

</div>

Hi @Dikshakapoor

> [@Dikshakapoor](#):
>
> the diff command seems to generate only the schema changes and not the data

Yes, the `diff` command will help you get following :

- Finding missing objects between one database and another
- Seeing that a change was made to your database
- Finding unexpected items in your database

You won’t be able to get the difference in data using `diff` command.  
**Liquibase doesn’t allow you to diff the data between two databases**. However you can generate the changelog only for the data in the database.

> [@Dikshakapoor](#):
>
> generating a change Log and then updating results in error since it says table already exists

That’s right. May be try generating changelog only for the data. But again if some data already exists in the tables, it might throw an error again.

Still just in case needed, you can generate changelog for your DB data using :

```auto
liquibase --changeLogFile=generateChange.xml --diffTypes=data generateChangeLog

```

You can again use multiple options of `generateChangeLog` command for including data from schemas.

Thanks!  
Rakhi Agrawal