This tool is designed to compare tables in Oracle databases.
It is commonly used during system rewrites or upgrades to verify differences between old and new batch processing results.
・DBMerge-run - The demo of this DBMerge.You can copy it anywhere to try.
・DBMerge-src - The source of this DBMerge.
・DBMerge-testData - Test data and test ddl for the demo.
・DBMerge-run/config/jdbc.properties
・DBMerge-run/config/merge.properties
・DBMerge-run/output/
・DBMerge-run/lib/ojdbc6-11.2.0.3.jar
・DBMerge-run/tables/
・AutoCreate.jar
・DBMerge.jar
Database connect config file.
Only support of Oracle database.
# the new db info
new.db.driver=oracle.jdbc.driver.OracleDriver
new.db.url=jdbc:oracle:thin:@192.168.99.100:1521:xe
new.db.username=DBM_NEW
new.db.password=password
# the old db info
old.db.driver=oracle.jdbc.driver.OracleDriver
old.db.url=jdbc:oracle:thin:@192.168.99.100:1521:xe
old.db.username=DBM_OLD
old.db.password=password
# only need to creating table diff config when you use [AutoCreate.jar]
new.create.schema.name=DBM_NEW
old.create.schema.name=DBM_OLD
comm.create.table.name=TABLE%
The merge file names for diff in [DBMerge-run/tables/].
You can control this file to diff the table what you want, the merge file would be create by only once.
TABLE1.properties
TABLE2.properties
TABLE3.properties
The Merge result output folder.
One table merge result would be output by three files like this
TABLE1.properties_diffColumn.txt
TABLE1.properties_newOnly.txt
TABLE1.properties_oldOnly.txt
The JDBC driver of Oracle.
The merge config of tables.
You can use [AutoCreate.jar] to auto create merge config.
# merge info of new table
new.table.name=TABLE1
new.table.key.column=COLUMN1
new.table.merge.column=COLUMN1,COLUMN2,COLUMN3,COLUMN4,COLUMN5,COLUMN6,COLUMN7,COLUMN8,COLUMN9,COLUMN10,COLUMN11
new.table.merge.filter=AND COLUMN1 = '01'
# merge info of old table
old.table.name=TABLE1
old.table.key.column=COLUMN1
old.table.merge.column=COLUMN1,COLUMN2,COLUMN3,COLUMN4,COLUMN5,COLUMN6,COLUMN7,COLUMN8,COLUMN9,COLUMN10,COLUMN11
old.table.merge.filter=AND COLUMN1 = '01'
・JAVA1.5 or earlier
・Oracle 10g or earlier
・CPU 2.4GHZ at least
・MOMERY 4G at least
You need only copy the [DBMerge-run] on your PC or server.
When you modified the sources,you need export the new jar file.
You can double click on it for run or use the command
java -jar DBMerge.jar
When you use the command, you can set the mutial thread parameters like this
java -jar DBMerge.jar 10 10
1. Fork it ( https://github.com/vekee/DBMerge.git )
2. Create your feature branch (git checkout -b my-new-feature)
3. Commit your changes (git commit -am 'Add some feature')
4. Push to the branch (git push origin my-new-feature)
5. Create new Pull Request
DUAN DAHAI