Comparison tools for DB2 databases
Do you want to compare DB2 Linux/Unix/Windows databases, structures, contents or configurations. Or do you want to compare table data or structures with DB2 for z/OS?Â Here’s list of products which could be useful:
- Embarcadero DB Change Manager:
Does not support DB2 for z/OS, but great for comparing DB2 UDB’s, compares even structures and database configurations.
Supports DB2 UDB’s and DB2 z/OS. Graphical tool,Â inappropriate for large amount of data, great for comparison of low volumes or SQL statements.
- Altova DataSpy:
Generally supports DB2 UDB and DB2 z/OS. Structural comparisons supported, but data comparison did not work (problem skipping differences in indexes and/or primary keys).
- SQLManager Data Comparer:
Not available for DB2, but for other popular database systems.
- AQT Advanced Query Tool:
Works, but objects have to be compared individually, one by one. Old-fashioned end-user front-end. Advanced edition required.
- SQL Maestro Data Sync:
Up-to-date front-end, available for all major database systems. Works for DB2 UDB, but does not support DB2 for z/OS.
- SQL Edit DTM Data Comparer:
Product supports DB2 for Linux/Unix/Windows and DB2 for z/OS. Its possible to select objects by schema name. Presentation of comparison results is a bit old-fashioned. Compare reports not suitable for large amount of tables and/or data.
If you know other useful tools, please send me an email.
Comments are closed.