cancel
Showing results for 
Search instead for 
Did you mean: 

Synch Check for Unit/QA/Prod Systems

Former Member
0 Kudos

Hi, We have requirement where we need to do synch up check between Development, Quality and Production Systems. We need to check whether all the views, tables procedure are in-synch ( have same structure ) in these three systems. Opening each view and comparing is time consuming especially when having large no of views.. Is there any backend system tables for views which contains details of these views (Like BW)?? through which we can compare?? Or is there any other technique to do this activity. Please help.... Thanks in Advance Regards, Amit.

Accepted Solutions (1)

Accepted Solutions (1)

lbreddemann
Active Contributor
0 Kudos

Technically you can of course access the repository back end tables.

However, this might be a rather difficult task to inside of the database or across databases since you will need to have a "deep" comparison of the different development artifacts.

So maybe a feasible way to achieve this is to perform complete model exports for each system and run diff on file system basis.

In any way, there is no standard tool for this delivered with SAP HANA. You will have to invent something yourself here.

- Lars

Former Member
0 Kudos

Thank you Lars for response.. So there is no backend table which store details of Attribute, Analytical Views? Such as there is table which stores metadata of tables staged in Hana.. Thanks in advance..

Answers (0)