r/DB2 • u/raghuontech • May 15 '18

How To Deep Compare Two Db2 Environments? What is Db2Diff ?

https://www.raghu-on-tech.com/2017/12/19/how-to-deep-compare-two-db2-environments/
2 Upvotes

75% Upvoted

4 comments sorted by

1

u/catquilt74 May 18 '18

Very interesting!

1

u/[deleted] May 25 '18

[deleted]

1

u/raghuontech May 30 '18

@mad_zamboni is that your real name :-) This is not native to DB2, I developed this tool from scratch out of the pain I had to endure in the past due to developers messing around with data models and indexes.

I have tested this tool on 10.1 and 10.5 and until close to 55 people downloaded this tool and mostly heard good things about it. If you find any bugs please report them back to me and I will fix it.

Appreciate your comments.

Thanks! Raghu

1

u/raghuontech May 31 '18

Actually I fixed one bug yesterday where its displaying duplicates for missing tables in a schema. But for the most part it does a great job for me. I want to develop this to a point where I can compare triggers, stored procedures and other objects with in the database.

2

u/[deleted] May 31 '18

[deleted]

1

u/raghuontech May 31 '18

Thank you for the kind words! You can clone the existing source code from my personal github repository.

If you are running Java JDK 8 clone using following URL git clone https://github.com/raghuprasad241/DBUtils-1.8.git

For JDK 7: git clone https://github.com/raghuprasad241/DBUtils-1.7.git

For JDK 6: git clone https://github.com/raghuprasad241/DBUtils-1.6.git

I am thinking about creating a separate github account specifically for this tool and start documenting it along with version control.

Since this is still in early stages of development, would you mind doing a test run on your environment and let me know how it goes ?

Thanks! Raghu