Simple helper to handle update / insert / delete in a SAFE mode.
Add maven dependency :
<dependency>
<groupId>org.fugerit.java</groupId>
<artifactId>db-compare</artifactId>
<version>${db-compare-version}</version>
</dependency> Sample usage :
try ( InputStream configIs = ...;
ConnectionFactoryCloseable cf1 = ...;
ConnectionFactoryCloseable cf2 = .. ) {
DBCompareConfig config = this.facade.readConfig( configIs );
String schema = "PUBLIC";
DBCompareOutput output = this.facade.compare( config, cf1, schema, cf2, schema );
// print include equals
log.info( "\nDiff (include equals)" );
DBCompareUtils.printDiff( output, true );
// print exclude equals
log.info( "\nDiff (exclude equals)" );
DBCompareUtils.printDiff( output, false );
}