I want to compare data of two databases with same structure(Comparison of data not the structure ) and create a change log

General Discussion
1

I want to compare data of two mysql databases with same structure(Comparison of data not the structure ) and create a change log file. Is there any option in liquibase for data comparsion.

I tried this one, but it is only generating the whole data present in the first database

liquibase --url=jdbc:mysql://localhost:3308/db1--username=root --password=root123# --referenceUrl=jdbc:mysql://localhost:3308/db2 --referenceUsername=root --referencePassword=root123# --diffTypes=data generateChangeLog

<changeSet author="abhija.j (generated)" id="1724837496924-1">
        <insert tableName="box_type">
            <column name="id" valueNumeric="1"/>
            <column name="user_group_id"/>
            <column name="created_date" value="2024-08-26T19:22:56.327243"/>
            <column name="updated_at" value="2024-08-26T19:22:56.327243"/>
            <column name="name" value="veify"/>
            <column name="category" value="test"/>
            <column name="type" value="GATEWAY"/>
        </insert>
    </changeSet>
    <changeSet author="abhija.j (generated)" id="1724837496924-2">
        <insert tableName="soc_vendor">
            <column name="id" valueNumeric="1"/>
            <column name="user_group_id"/>
            <column name="created_date" value="2024-08-28T13:00:28.670784"/>
            <column name="updated_at" value="2024-08-28T13:00:28.670784"/>
            <column name="name" value="SOC1"/>
            <column name="category" value="test"/>
        </insert>
        <insert tableName="soc_vendor">
            <column name="id" valueNumeric="2"/>
            <column name="user_group_id"/>
            <column name="created_date" value="2024-08-28T13:00:37.262673"/>
            <column name="updated_at" value="2024-08-28T13:00:37.262673"/>
            <column name="name" value="SOC2"/>
            <column name="category" value="test"/>
        </insert>
        <insert tableName="soc_vendor">
            <column name="id" valueNumeric="3"/>
            <column name="user_group_id"/>
            <column name="created_date" value="2024-08-28T13:00:42.402321"/>
            <column name="updated_at" value="2024-08-28T13:00:42.402321"/>
            <column name="name" value="SOC3"/>
            <column name="category" value="test"/>
        </insert>
        <insert tableName="soc_vendor">
            <column name="id" valueNumeric="4"/>
            <column name="user_group_id"/>
            <column name="created_date" value="2024-08-28T13:14:15.686541"/>
            <column name="updated_at" value="2024-08-28T13:14:15.686541"/>
            <column name="name" value="SOC4"/>
            <column name="category" value="test"/>
        </insert>
        <insert tableName="soc_vendor">
            <column name="id" valueNumeric="5"/>
            <column name="user_group_id"/>
            <column name="created_date" value="2024-08-28T13:14:20.576499"/>
            <column name="updated_at" value="2024-08-28T13:14:20.576499"/>
            <column name="name" value="SOC5"/>
            <column name="category" value="test"/>
        </insert>
        <insert tableName="soc_vendor">
            <column name="id" valueNumeric="6"/>
            <column name="user_group_id"/>
            <column name="created_date" value="2024-08-28T13:15:19.439335"/>
            <column name="updated_at" value="2024-08-28T13:15:19.439335"/>
            <column name="name" value="SOC6"/>
            <column name="category" value="test"/>
        </insert>
    </changeSet>
    <changeSet author="abhija.j (generated)" id="1724837496924-3">
        <insert tableName="user">
            <column name="id" valueNumeric="1"/>
            <column name="user_group_id" valueNumeric="1"/>
            <column name="user_role_id" valueNumeric="1"/>
            <column name="updated_at" value="2024-08-28T12:55:45.451"/>
            <column name="created_date" value="2024-08-26 19:22:08"/>
            <column name="display_name" value="Admin User"/>
            <column name="email" value="admin@gmail.com"/>
            <column name="password" value="ffff"/>
            <column name="status"/>
            <column name="username" value="admin"/>
            <column name="theme" value="DARK"/>
        </insert>
    </changeSet>
    <changeSet author="abhija.j (generated)" id="1724837496924-4">
        <insert tableName="user_group">
            <column name="id" valueNumeric="1"/>
            <column name="created_date"/>
            <column name="updated_at"/>
            <column name="name" value="usergroup1"/>
        </insert>
        <insert tableName="user_group">
            <column name="id" valueNumeric="2"/>
            <column name="created_date"/>
            <column name="updated_at"/>
            <column name="name" value="usergroup2"/>
        </insert>
    </changeSet>
    <changeSet author="abhija.j (generated)" id="1724837496924-5">
        <insert tableName="user_role">
            <column name="id" valueNumeric="1"/>
            <column name="created_date"/>
            <column name="updated_at"/>
            <column name="name" value="admin"/>
        </insert>
        <insert tableName="user_role">
            <column name="id" valueNumeric="2"/>
            <column name="created_date"/>
            <column name="updated_at"/>
            <column name="name" value="tester"/>
        </insert>
    </changeSet>
</databaseChangeLog>

I tried the command -

 liquibase diff-changelog --changelog-file=example-changelog.xml --url="jdbc:mysql://localhost:3308/tdktestmanagerproddb" --username=root --password=root123# --reference-url="jdbc:mysql://localhost:3308/tdktestmanagerproddbold " --reference-username=root --reference-password=root123#

Got this output -

Starting Liquibase at 19:29:02 using Java 21.0.2 (version 4.29.1 #3316 built at 2024-07-30 20:15+0000)
Liquibase Version: 4.29.1
Liquibase Open Source 4.29.1 by Liquibase
BEST PRACTICE: The changelog generated by diffChangeLog/generateChangeLog should be inspected for correctness and completeness before being deployed. Some database objects and their dependencies cannot be represented automatically, and they may need to be manually updated before being deployed.
Liquibase command ‘diff-changelog’ was executed successfully.

But file is not generated