Skip to Content
Author's profile photo Paul Aschmann

Syscompare – a tool for comparing repos across HANA instances

/wp-content/uploads/2015/06/compare_icon_726708.png

A couple of weeks ago I was moving code from 1 hana instance to another trying to keep them in sync. However, I thought there might be a better alternative for comparing the contents of the repos across my systems to ensure that the files matched. After doing some digging and not finding a solution, I decided to write a small tool to do just this, called Syscompare. It is a open source HANA app which uses the new File API and compares the files on each system and displays the differences.

You can read more about the application here, and find the files for the HANA app in Github.

Features:

– Compare repos across HANA instances

– Display file differences in the application

– Highlights missing files on each instance

Usage:

– Setup the 2 XSHttpDest files

– Specify the source and target systems (using the xshttpdest file names)

– Specify the repo to compare

Once the processing is complete the app will show a summary of differences:

Screen Shot 2015-06-16 at 10.18.20 PM.png

Screen Shot 2015-06-16 at 10.20.12 PM.png

Screen Shot 2015-06-16 at 10.20.51 PM.png

You can checkout the Github/Source code here: paschmann/Syscompare · GitHub

If you prefer to download the Delivery Unit – please click here and provide your email address (this way I can keep you up to date with changes): metric² | Real-time operational intelligence for SAP HANA

Interested in contributing to the project? Please feel free to fork or submit a pull request.

Assigned Tags

      4 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Ashwini Chaturvedi
      Ashwini Chaturvedi

      Hi Paul,

      Such a nice tool. I was looking for exactly this one. I tried to import files, it seems it doesn't support SPS8. Can you pls confirm?

      Regards,

      Ashwini

      Author's profile photo Paul Aschmann
      Paul Aschmann
      Blog Post Author

      Hi Ashwini, thanks for your comments - unfortunately it requires SPS09 since the File API was only introduced in this version.

      Paul

      Author's profile photo Ashwini Chaturvedi
      Ashwini Chaturvedi

      Thanks Paul for the confirmation. By any chance do you have some pointers on  how can I do repository comparison in SPS08.

      Regards,

      Ashwini

      Author's profile photo Paul Aschmann
      Paul Aschmann
      Blog Post Author

      Hi Ashwini,

      I unfortunately don't - my only suggestion would be to download the file contents/repos and compare them with a 3rd party tool. I wonder what other hana developers/admins may use?

      Cheers, Paul