How can I get Data Diff using java dependency

General Discussion
1

Hello Team, 

I use liquibase 3.5.3 in my java project. I’m trying to get the differences between 2 databases.

I use the code bellow. It give me difference of structure, but doesn’t show differences on data (nor the difference on foreign key that does not named exactly the same). Do you know if this is something that is possible that way?

Thanks in advance.

Database referenceDatabase = DatabaseFactory.getInstance().findCorrectDatabaseImplementation(new JdbcConnection(referenceConnection));

        Database targetDatabase = DatabaseFactory.getInstance().findCorrectDatabaseImplementation(new JdbcConnection(targetConnection));

       SchemaComparison[] sc = new SchemaComparison[]{new SchemaComparison(referenceDatabase.getDefaultSchema(), targetDatabase.getDefaultSchema())};

        

        liquibase = new Liquibase("", new FileSystemResourceAccessor(), referenceDatabase);

         

        List<Class<? extends DatabaseObject>> objectTypesToDiff = new ArrayList<Class<? extends DatabaseObject>>(); 

        

        objectTypesToDiff.add(Table.class); 

        objectTypesToDiff.add(View.class); 

        objectTypesToDiff.add(Column.class); 

        objectTypesToDiff.add(Index.class); 

        objectTypesToDiff.add(ForeignKey.class); 

        objectTypesToDiff.add(PrimaryKey.class); 

        objectTypesToDiff.add(UniqueConstraint.class); 

        objectTypesToDiff.add(Sequence.class); 

        objectTypesToDiff.add(Data.class);

        objectTypesToDiff.add(Schema.class);

        objectTypesToDiff.add(Catalog.class);

        

        CompareControl cc = new CompareControl(sc, new HashSet(objectTypesToDiff));

        

        DiffResult diffResult = liquibase.diff(referenceDatabase, targetDatabase, new CompareControl(sc, new HashSet(objectTypesToDiff)));

       

        DiffToChangeLog changeLogWriter = new DiffToChangeLog(diffResult, new DiffOutputControl());